I need to use a special character in a query and this causes me some problem. Basically, I need to search for:

SELECT * FROM MyTable WHERE MyField LIKE '%[signature]%'

However, the [ and ] characters are reserved and this creates a weird result. How can I adjust that query to make sure that [ and ] are really interpreted as a character?