Deprecated: Function create_function() is deprecated in /var/www/vhosts/eduardoarellano.com/d4mations.com/wp-content/plugins/wp-automatic/wp-automatic.php on line 70
Quickly Find and Replace Text in MySQL | D4mations.com
  • Wednesday , 25 November 2020

Quickly Find and Replace Text in MySQL

Code Canyon

For a single table update

UPDATE `table_name`
SET `field_name` = replace(same_field_name, 'unwanted_text', 'wanted_text')

From multiple tables-

If you want to edit from all tables, best way is to take the dump and then find/replace and upload it back.

 

 

 

3d Ocean

Related Posts

Leave A Comment

You must be logged in to post a comment.