On 3/3/07, A.J.Millan <[EMAIL PROTECTED]> wrote:
Hi all:
I need a simple search, say:
SELECT someField IN someTable WHERE name LIKE '%xyzetc%';
This is standard SQL syntax, and works just fine in SQLite. It will
match all rows where someField contains the string 'xyzetc'
You can also anchor the string by using either '%xyzetc' or 'xyzetc%'
if desired.
..
Can I use some like:
SELECT someField IN someTable WHERE name LIKE '<?>xyzetc<?>' ESCAPE <?>;
I don't have experience with the ESCAPE clause, but even if your
syntax above were correct, you would find only those rows where
someField is exactly like '<?>xyzetc<?>', and I think that is not what
you want.
Just use '%xyzetc%' and you will be fine.
--
Puneet Kishor http://punkish.eidesis.org/
Nelson Inst. for Env. Studies, UW-Madison http://www.nelson.wisc.edu/
Open Source Geospatial Foundation http://www.osgeo.org/education/
---------------------------------------------------------------------
collaborate, communicate, compete
=====================================================================
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
