2020-04-21

search and replace in a mysql table

This is the code:

UPDATE `table_name`
SET `field_name` = replace(field_name, 'old_text', 'new_text')

No comments:

Post a Comment

Blog Archive