Campbell, Lance wrote:
> I am having an issue with trying to use 'LIKE' so that I can match on a
> string with an underscore in it. What is the proper way to find the
> following string?
> WARNING: nonstandard use of escape in a string literal
> LINE 1: ...ct c1 from t1 where c1 like '%abc\_%';
Either indicate you are using an escaped string: LIKE E'%abc\_%'
Or, change the escape character: LIKE '%abcQ_%' ESCAPE 'Q'
In response to
pgsql-sql by date
|Next:||From: Tom Lane||Date: 2008-02-13 16:52:41|
|Subject: Re: Like problem |
|Previous:||From: Campbell, Lance||Date: 2008-02-13 16:30:31|
|Subject: Like problem|