I'm using statements from here:
<em><a href="http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/" rel="nofollow noreferrer">http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/</a></em>
but i had to modify them because i'm using multi-user and it has different table structure (weird numbered tables). As you can see in my <a href="https://stackoverflow.com/questions/2122049/mysql-wildcard-ignore-one-two-characters-in-search">previous question</a> it's all REALLY problematic... So my question is:
Can i just change <em><a href="http://old-domain.com" rel="nofollow noreferrer">http://old-domain.com</a></em> to <em><a href="http://new-domain.com" rel="nofollow noreferrer">http://new-domain.com</a></em> everywhere... in every table in that database? How do i do such search and replace with mysql? Or maybe something else would be better to use for this task?
<em><a href="http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/" rel="nofollow noreferrer">http://www.mydigitallife.info/2007/10/01/how-to-move-wordpress-blog-to-new-domain-or-location/</a></em>
but i had to modify them because i'm using multi-user and it has different table structure (weird numbered tables). As you can see in my <a href="https://stackoverflow.com/questions/2122049/mysql-wildcard-ignore-one-two-characters-in-search">previous question</a> it's all REALLY problematic... So my question is:
Can i just change <em><a href="http://old-domain.com" rel="nofollow noreferrer">http://old-domain.com</a></em> to <em><a href="http://new-domain.com" rel="nofollow noreferrer">http://new-domain.com</a></em> everywhere... in every table in that database? How do i do such search and replace with mysql? Or maybe something else would be better to use for this task?