subject:"\[sqlite\] Parenthetical LIKE query \?\?"

Re: [sqlite] Parenthetical LIKE query ??

2009-01-04 Thread P Kishor

On 1/4/09, Ben Marchbanks 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

Re: [sqlite] Parenthetical LIKE query ??

2009-01-04 Thread Igor Tandetnik

"Ben Marchbanks" wrote in message news:49615144.7090...@alqemy.com > SELECT * FROM `pagesText` WHERE pageText LIKE ( "%muffler%" , > "%clamp%" ) > > Is there a nice way to write a query using parenthetical LIKE ? SELECT * FROM pagesText WHERE pageText LIKE '%muffler%' OR

[sqlite] Parenthetical LIKE query ??

2009-01-04 Thread Ben Marchbanks

SELECT * FROM `pagesText` WHERE pageText LIKE ( "%muffler%" , "%clamp%" ) Is there a nice way to write a query using parenthetical LIKE ? Queries like this can get quite long otherwise Any suggestions ? *Ben Marchbanks* www.magazooms.com Signature Email: