like with '\' - Mailing list pgsql-general

From Nicolas Paymal
Subject like with '\'
Date
Msg-id LJEIJOMPNLMBFJLMFLKACECICFAA.npaymal@instranet.com
Whole thread Raw
List pgsql-general
Is there a way to use like for searching a '\' ?
I have a column which contains a windows path ex c:\temp\foo
I 'am searching all entries which contains this path but I never match.
I tried :
like 'c:\temp\foo%'
like 'c:\\temp\\foo%'
like 'c:&\temp&\foo%' escape '&'

is there another way ?




pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: FW: Merging databases
Next
From: Thomas O'Dowd
Date:
Subject: [Fwd: Re: like with '\']