Change particular text or url in page content on wordpress using MYSQL?

2 comments

1. Use the REPLACE() function:

   UPDATE yourTableName
   SET columnName = REPLACE(columnName , 'www.anbomanufacturing.com/LitForm.html', 
                    'http://192.185.104.157/~anbomanu/product-literature');
   

   Log in to Reply

2. try with this, and place this code in your functions.php file to replace the link from the content:

   add_filter('the_content', 'link_replacer');
   
   function link_replacer ($content = '') {
       $pattern = "/anbomanufacturing.com/LitForm.html/";
       $replace = "192.185.104.157/~anbomanu/product-literature";
   
       return preg_replace( $pattern, $replace, $content );
   } 
   

   for more information take a look on the the_content Filter

   Log in to Reply