Tuesday 22 December 2015

How to replace text in a particular column in a table in phpmyadmin?

Use the REPLACE function with a UPDATE statement:


UPDATE table_name
SET column_name= REPLACE(
column_name, 'search_text', 'replacement_text')



7 comments: