Re: Escaping underscores in LIKE

From: "Tom Lane" <tgl@sss.pgh.pa.us>

> dev@archonet.com writes:
> > Am I doing something stupid trying to escape an underscore in LIKE?

Ah so Yes.

> You need more backslashes.  Don't forget the string-literal parser eats
> one level of backslashes, before LIKE ever gets to see the pattern.
>
> regards, tom lane

Thanks Tom, as a 2-stage process it all makes sense. Tried it out in PHP too
and I end up with four backslashes (3 stages).

Another DOH! item for my notes.

- Richard Huxton