Re: BUG #2125: SELECT problem with strings containing \ - Mailing list pgsql-bugs

"Tony" <tonya@ananzi.co.za> writes:
> When running a query such as:
> select folder from public.folders
> where lower(folder) like '%c:\\1%'
> no rows are returned

This is not a bug --- you've forgotten that backslash is an escape
character in LIKE patterns.  You can either double it again:

    like '%c:\\\\1%'

or select a different escape character, or maybe better not have any
escape character at all:

    like '%c:\\1%' escape ''

See
http://www.postgresql.org/docs/8.1/static/functions-matching.html#FUNCTIONS-LIKE

            regards, tom lane