Looking for an SQL Query to replace text in signatures

[beansbaxter]

This is the query I run to replace text in posts:

UPDATE post
SET pagetext = REPLACE(pagetext,'OLD','NEW')

What is the query to replace text in signatures?

Thanks in advance.

[motd2]

UPDATE sigparsed
SET signatureparsed = REPLACE(signatureparsed,'OLD','NEW')

[Mark.B]

You may need to empty the signature cache in AdminCP > Maintenance > Rebuid Counters afterwards.