Answers for "replace in mysql string"

PHP
6

mysql replace a character in a string

UPDATE users SET first_name = REPLACE (first_name, 'search', 'replace_with') where id > 0;
Posted by: Guest on June-20-2019
13

mysql replace

REPLACE(str, find_string, replace_with)
Posted by: Guest on May-26-2020
1

update and replace mysql

#Search, Update & Replace Query

UPDATE `tblname` SET `description`= REPLACE(`description`, 'old name', 'New Name') WHERE `description` LIKE '%old name%';
Posted by: Guest on April-24-2021

Browse Popular Code Answers by Language