[thelist] SQL question

[Tom Dell'Aringa]

Hello,

During a transfer to wordpress my comments all got borked with the wrong name/e-mail. I want to go
directly into the DB to fix this. 

I have the table 'comments' with the fields author and author_email.

What I want to do is REPLACE all occurances of 'TSF' in author with 'anonymous' 

and then

Replace all occurrances of my email with a blank or null. 

I not quite sure how to do a replace - and I don't want to try something and screw up my DB even
if I do have a backup! Any help is appreciated.

Tom

=====
Get Firefox! | http://www.pixelmech.com/