newly converted - getting \" instead of "

[siteworthy]

We converted over from phpBB about a week ago and it appears that anywhere we had a " we now have a \". What's the best way to get this resolved? I see it in text of posts and here and there in subjects and signatures as well. Was thinking this will probably require running a SQL script but not sure what that would be.

[Lats]

...this will probably require running a SQL script...

I think you're right

For posts...

UPDATE
post
SET 
pagetext = replace(pagetext,'\\"', '"') 
WHERE 
pagetext
LIKE '%\\\\"%'

For titles...

UPDATE
thread
SET
title = replace(title,'\\&quot','&quot')
WHERE
title
LIKE '%\\\\"%'

For signatures...

UPDATE
usertextfield
SET
signature = replace(signature,'\\"','"')
WHERE
signature
LIKE '%\\\\"%'

[siteworthy]

Great! Thanks...one more thingq

Okay to do this while the board is up and running? I do stuff similar to this in a SQL Server database that I work on at work so... just curious.

[Lats]

I can't imagine a problem doing it live.