Answers for "mysql query to replace 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
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

Code answers related to "mysql query to replace string"

Browse Popular Code Answers by Language