Find the SQL tab and paste the following in the command box.
In the example below, I’m searching the WordPress table
post_content to find and replace something. Change the information between the quotes ‘Item to replace here‘ with what you want to find and change the information between the quotes ‘Replacement text here‘ with what you want to replace. Then click “Go.”
UPDATE wp_posts SET post_content = REPLACE ( post_content, 'Item to replace here', 'Replacement text here');
Note: Depending on your WordPress setup, your
wp_posts may have a prefix, like
abc_wp_posts but normally the first is the default name of the table. However,
post_content doesn’t change.