mysql replace a character in a string
snippet in php

mysql replace a character in a string

user6236

UPDATE users SET first_name = REPLACE (first_name, 'search', 'replace_with') where id > 0;