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 can match for each p
"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 pageText LIKE '%clamp%'
2 matches
Mail list logo