Sql Help And Problem

[dumbfatguy]

I need some help with SQL
For some "dumb reason" I wasn't aware you could delete attachements out of the attachment manager. So I went Into my FTP and deleted all the attachments before JAN 1 2003, So even though the files are not there there Are still in mySQL data base. In the attachment size and attachment name fields, there for screwing up my attachment manager.
So I'm sure there Is a way I could "purge" just they entries for Attachment size and Attachment file name for before Jan 1 2003 but I am not sure what the syntax would be.

Also I want just to clear out those Fields and not all the messages.

I hope this makes sense and someone can help me out a little bit, thanks for your time.

[[Unknown]]

UPDATE yabbse_messages
SET attachmentFilename = NULL, attachmentSize = 0
WHERE posterTime <= UNIX_TIMESTAMP('2003-01-01');

Should work.

-[Unknown]

[dumbfatguy]

Sweet that worked like a charm, thank very much