SQL Query Help

[IceBurn3000]

My bad. I meant the "post" table, not the "users" table. Yesterday was too long a day.

In the "post" table it appears that it keeps the record of the "username" when you delete a user and not their posts, but makes the "userid" 0 so it won't link to a non-existant profile. What I want to do, if possible, is to run an SQL Query on the "post" table to find all records with a specific username (eg. user101) and change the "userid" for each of those records to 9.

I could do this manually with phpMyAdmin, but there's over 1000 posts, so I am hoping there is an SQL Query that can do this.

Thanks for trying to help with the wrong info I provided, Hellcat :P I just hope you or someone can help me now with the correct info.