April 7, 2015 in Technical Problems
Is there a easy way to find and replace text from posts? For example, I am wanting to change all instances of one URL (http://xxxxxx.com/xxxxx) to (http://yyyyy.com/xxxxx) I am thinking an SQL command, but I tried this SELECT REPLACE ('http://xxxxxx.com/','http://xxxxxx.com/','http://yyyyy.com/') and it ran but didn't update anything.
Should be something like this ..
SET column = REPLACE( column, 'xxxxx.com', 'yyyyy.com')
WHERE column like '%xxxxx.com%';
Isn't there a word replace tool for swear words ect...?
Believe that only works on posts moving forward, not anything that has already been posted.
Should be something like this ..UPDATE tableSET column = REPLACE( column, 'xxxxx.com', 'yyyyy.com')WHERE column like '%xxxxx.com%';
Would this replace the actual text in the posts? That is what I am trying to change. The board migrated over to the new URL fine and I updated the global file. No issues there. I am trying to change any text/links that people posted referencing the old domain. In theory, the 301 redirect should cover it, but I'd like to clean it up if possible.
Yes. You will have to find the right table and column but it will replace anything that matches that string value.
Yes. Same what he said .. If you not feel so familiar with MySQL, please make a test database first with a simple table where you can test this replacement function first, and check the result ..
This topic is now archived and is closed to further replies.
Started 1 hour ago
Started 10 hours ago
Started Monday at 08:21 PM