how to look for wildcards in the database

[jasongr]

Hello

I know that the % and _ wildcards can be used in conjunction with LIKE to perform powerful queries.
I would like to be able to look for these letters as part of my query though.
For example, If I look for the letter %, then the entry '5%' should be found.

Similarly for the letter _
if I look for _ then it should find the entry 'an underscore is _'

Can anyone tell me how I can escape these special wildcards in my search?

regards

[Dean C]

You have to use the escape character like so:

\_ or \%

[jasongr]

so if I look for:
%\%%
it will find anything that contains a '%' ?

[r937]

find an underscore --

... where foo like '%^_%' escape '^'

find a percent sign --

... where foo like '%?%%' escape '?'