I need to update Aleksander Šeliga to Aleksander Seliga with Mysql update do we have any suggestion that how we can achieve this?
CREATE TABLE
CREATE TABLE `tbl_players` (
`player_id` int(11) NOT NULL AUTO_INCREMENT,
`player_name` varchar(100) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL,
`status` smallint(2) NOT NULL DEFAULT 1
PRIMARY KEY (`player_id`),
UNIQUE KEY `isg_api_id` (`isg_api_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8
INSERT into Table
INSERT INTO `tbl_players` (`player_id`, `player_name`,`status`) VALUES
(1,'Aleksander Šeliga',1);