Re: How to match percent sybmol in LIKE operator? - Mailing list pgsql-general

Sergey Filatov wrote:
>
> Greetings.
>
> My problem is to find percent character in some field.
> I'm wonder how specify percent character or other wildcard characters
> in 'LIKE patterns'?
>
> Many thanks in advance,
> Sergey.

You have escape them with the backslash. In order to pass the backslash
to the backend you have to escape the backslash as well:

select * from xxx where yyy like '\\%';

It might be a good idea to point this out in the Postgresql book :-)

With kind regards,
    Holger Klawitter
--
Holger Klawitter
holger@klawitter.de                             http://www.klawitter.de