My client started their WordPress website with a domain and hard-coded it to not have a "www." in front of the domain. Unfortunately, this caused problems on the local "windows domain" network in the office. The LAN technician said that the website had to be changed to include "www." we did, and now we need to adjust all the references to images and pages in the website that currently do not have a "www.".
Therefore, I am looking for one or more SQL statements
that I can execute in MyPHPAdmin to change all references of "http://domain.com
" to "http://www.mydomain.com
". This would be in at least these two fields of the wp_posts
There might be other fields in this table and there might be other tables to modify, too. I am not sure.
I am not an expert on MySQL, so I am not sure how to formulate the SQL statements. I am also not expert enough in WordPRess to know if there are other fields and tables to search through or not.