Answers for "replace text in mysql"

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

mysql find and replace

UPDATE `table` SET `column` = replace(`column`, 'find text', 'replace text')
Posted by: Guest on May-21-2021

Browse Popular Code Answers by Language