Warning: Creating default object from empty value in /home/mayankra/public_html/wp-content/themes/salient/nectar/redux-framework/ReduxCore/inc/class.redux_filesystem.php on line 29

Deprecated: Unparenthesized `a ? b : c ? d : e` is deprecated. Use either `(a ? b : c) ? d : e` or `a ? b : (c ? d : e)` in /home/mayankra/public_html/wp-content/plugins/js_composer_salient/include/classes/editors/class-vc-frontend-editor.php on line 653
How to write Find & Replace Query in Wordpress? - Top Website & Mobile Application Development Team
Notice:Trying to access array offset on value of type bool in /home/mayankra/public_html/wp-content/themes/salient/nectar/helpers/media.php on line 368

Notice: Trying to access array offset on value of type bool in /home/mayankra/public_html/wp-content/themes/salient/nectar/helpers/media.php on line 368
UPDATE `TABEL_NAME`
 SET `FIELD NAME` = replace(`FIELD NAME`, 'unwanted Text', 'Wanted Text')

 

for example,


UPDATE `wp_options`
 SET `option_value` = replace(`option_value`, '192.168.1.174', '192.168.1.188');
 
 UPDATE `wp_postmeta`
 SET `meta_value` = replace(`meta_value`, '192.168.1.174', '192.168.1.188');

 UPDATE `wp_posts`
 SET `post_content` = replace(`post_content`, '192.168.1.174', '192.168.1.188');
 
 UPDATE `wp_posts`
 SET `guid` = replace(`guid`, '192.168.1.174', '192.168.1.188');

 

Leave a Reply