Re: [SQLObject] _likeQuote

[Oleg B. <ph...@ph...>]

On Fri, Nov 05, 2004 at 03:06:18PM -0600, Ian Bicking wrote:
> >   Quoting?
> 
> If you want to search for all fields that contain the text "100%" 
> (literally, not treating % as a wildcard) you would search for

   That's exactly what I want...

> field LIKE "%100%%%"

   ...but as I have said in the first message, both Postgres and MySQL
use different quoting style. They use backslash to quote % and _:

   LIKE "%100\%%"

I have consulted documentation for Postgres 7.3 and MySQL 4.0 before
asking about double percent.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.