Page 1 of 1

valid string to mass find & replace in database

PostPosted: Sat Oct 02, 2010 2:46 pm
Author: viragotech
"valid string to mass find & replace in database"

Would this be safe to use.

mysql> SELECT REPLACE('http://viragotechforum.com/phpBB/', '/phpBB/', '/');


So it will make even a link like this in a thread right
[when I upgraded to 141 on shared, I dropped the phpBB]

http://viragotechforum.com/phpBB/postin ... e&p=222761


http://viragotechforum.com/posting.php? ... e&p=222761

Re: valid string to mass find & replace in database

PostPosted: Sun Oct 03, 2010 12:13 am
Author: Helter
that would be a question for your host because it will use a lot of system resources on a live db the size of yours.