replace all data select mysql code example
Example 1: mysql replace a character in a string
UPDATE users SET first_name = REPLACE (first_name, 'search', 'replace_with') where id > 0;Example 2: mysql replace
REPLACE(str, find_string, replace_with)UPDATE users SET first_name = REPLACE (first_name, 'search', 'replace_with') where id > 0;REPLACE(str, find_string, replace_with)