how to edit a mysql?

[kuzukuzu]

hello, i have a vbulletin sql.

i want to mass replace words as fuck, xxx for permanently

there are like 100k posts

how can i edit this?

i dont want to use the replace word option in admincp, how can i edit directly in the sql file?

any tools?

 

[desiboy]

Unix / Linux

sed -i ‘s/fuck/xxx/g’ sql_file.sql

 

[Lock Down]

I don't know the name of your VB post table but here is the mySQl command.

update post set pagetext=replace(pagetext,'fuck','xxxx')

This is without a prefix for the table. You may have to add a prefix in front of post like vb_post or whatever. When you are in phpmyadmin it will show you if there is a prefix.

Make sure you have a db backup in case you type something wrong.

 

[Doublecrosser]

just censor the words from admincp, thats the easiest way to replace them.