----- Original Message ----- 
From: "Igor Tandetnik" <[EMAIL PROTECTED]>
To: "SQLite" <sqlite-users@sqlite.org>
Sent: Sunday, March 04, 2007 12:59 AM
Subject: [sqlite] Re: Newbie question about LIKE and ESCAPE


> For example, this query retrieves all rows where someField contains '%'
> character:
>
> SELECT * FROM someTable WHERE someField LIKE '%\%%' ESCAPE '\';
>
> > Can I use some like:
> >
> > SELECT someField IN someTable WHERE name LIKE '<?>xyzetc<?>' ESCAPE
> > <?>;
>
> No. ESCAPE should be followed by a string consisting of exactly one
> character.
>

Leaving to a side the mentioned example (that is possibly a very old
comment), I had really misinterpreted the meaning and objective of the
ESCAPE clause. Now, thanks to yours comments and to Igor's example,
everything is clear and my querys works properly.

By the way, some simple examples next to each epigraph in the on-line manual
would be a lot of help.  Maybe a system of comments from the readers, as the
one in MySQL or PHP (I believe to remember).

Thaks to all.

A. J.Millan
ZATOR Systems


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to