MYSQL if a String contains special characters can we replace that with normal Šeliga-> Seliga with UPDATE Query?

Viewed 18

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);
0 Answers
Related