WordPress.org

1. vskylabv
   Member
   Posted 9 months ago #

   Hi all...

   I'd like to do a query to remove all instances where http://www.mywebsite.com is located and replace it with mywebsite.com - removing the www. Could anyone help me on this?

   I did a search and there's just too many to go one by one and I found some tables have a lot of extra things surrounded by the http://www.mywebsite.com. So I don't want it to replace the entire cell but only the text inside the cell that contains http://www.mywebsite.com

   Makes sense?

   Thanks!

2. Samuel B
   moderator
   Posted 9 months ago #

   http://wordpress.org/extend/plugins/search-and-replace/

3. vskylabv
   Member
   Posted 9 months ago #

   The plugin doesn't search and replace ALL tables. Only default wordpress tables.

4. Mark / t31os
   Moderator
   Posted 9 months ago #

   Then you'll need to compile your own SQL to meet your specific requirements.

   http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace
   http://www.google.com/search?q=mysql+replace

Reply

You must log in to post.