valid string to mass find & replace in database

Support for IntegraMOD 141

Moderator: Integra Moderator

valid string to mass find & replace in database

PostAuthor: viragotech » Sat Oct 02, 2010 2:46 pm

"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
User avatar
viragotech
Sr Integra Member
Sr Integra Member
 
Posts: 292
Likes: 0 post
Liked in: 0 post
Joined: Wed Jul 04, 2007 11:30 am
Cash on hand: 0.00

Re: valid string to mass find & replace in database

PostAuthor: Helter » Sun Oct 03, 2010 12:13 am

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.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4168
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 4:46 pm
Cash on hand: 187.60
Location: Seattle Wa
IntegraMOD version: IM 3


Return to IntegraMOD 141

Who is online

Registered users: Google [Bot], Vendethiel

cron