On Sat, 28 Jul 2001, Roy Souther wrote:
> In PG the _ is a wildcard that means any singal char. I need to do a search
> for the actual _ char and not get back thousands of wrong matches. Is there
> and escape char that I could use? This needs to work with PG 7.0.3 & 7.1.2.
\\_ should work for a literal escape.
At least on current sources you can do something like:
like 'blah!_%' escape '!'
where ! becomes the escape character for the string.