Need help with an SQL Query

[SnapOff Racing]

I need a query that I can execute so that I can turn "SHOW SIGNATURES" on for a certain user. You know how when you make a post and you have the option to "Show your Signature". Well if a user never created a signature from the day he signed up and then all the sudden creates one, that signature will not show up for all his past posts but only his future ones. So I need to create a query so that I can SELECT all the posts made from a certain user from the POST table and then execute another query to change the "showsignature" field from 0 to 1

EXAMPLE:
If I execute this query UPDATE post SET showsignature = 1 it will enable show signatures on every user that has made a post. So I was thinking that I need to run another query before that but I am having some trouble with the syntax. Here's what I got so far...

SELECT BillGates FROM `myforum`.`post`.`username`

But that syntax is obviously incorrect. So if any help would be appreciated :up:

[vbplusme]

This will update every post that BillGates has done where the signature is missing.


UPDATE `myforum`.`post` SET `showsignature` = '1' WHERE `post`.`username` ='BillGates' AND `showsignature`= '0'


HTH

[SnapOff Racing]

And that Michael is why YOU'RE THE MAN :D

Thanks worked PERFECT! :up: