Using ‘replace’ you can find and replace text of a column in a table.
Example of Replace text:
UPDATE `tbl` SET `field_name` = replace(field_name, 'old_text', 'new_text');
For any types of queries, you can contact us on info[at]namasteui.com.
MySQL – Find and Replace text in a table
