On 1/4/09, Ben Marchbanks <[email protected]> wrote: > SELECT * FROM `pagesText` WHERE pageText LIKE ( "%muffler%" , "%clamp%" ) > > Is there a nice way to write a query using parenthetical LIKE ?
afaik, there is no option for using LIKE in the manner of IN (as you are trying to do above). You can match for each pattern separately using OR between each clause. Also, use double quotes to quote the table or column names and single quotes to delimit the pattern... so, you should use SELECT * FROM "pagesText" WHERE pageText LIKE '%muffler%' OR pageText LIKE '%clamp%'; > > Queries like this can get quite long otherwise.... > > Any suggestions ? > > > *Ben Marchbanks* > > www.magazooms.com <http://www.magazooms.com/> > Signature > Email: [email protected] <mailto:[email protected]> > Phone: (864) 284.9918 > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
