How do I add a signature to my old posts?

[lsatblu]

Hi there,

I have made about 100 posts on my message board and I just decided to start using a signature with an image in it. All my new posts have the signature image at the bottom, but my old posts do not.

I could go back and edit each page and check "Show your signature", but is there an easier way to do this?

Thanks! :]

[Lats]

Give this query a spin...

UPDATE
    post
SET
    showsignature = 1
WHERE
    userid = 1
AND
    showsignature = 0

That assumes your userid is 1

[lsatblu]

I got the following error:

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1054 
error desc: Unknown column 'showsignture' in 'where clause'

[Lats]

I edited my post to show the correct spelling of signature

[lsatblu]

It worked! Thank you so much.