>Does this make sense:
>select * from table_name where column_1 LIKE "%word1% OR %word2%";
That should be:
column_1 LIKE "%word1%" OR column_1 LIKE "%word2%"
>yeilds 1 record but...
>select * from table_name where column_1 LIKE "%word2% OR %word1%";
>yields 0 records.
>I'm scanning a VARCHAR column trying to return records that contain or
>word1 and word2. Same thing occurs when I replace OR with AND. The
>search words appear appear in the column as:
> word1 followed by word2.
>Am I using the LIKE incorrectly? Does MySQL have to match the first LIKE
>operator before the second?
Paul DuBois, paul@stripped
|• LIKE||Eric Fegraus||3 Jul|
| • Re: LIKE||David Robley||3 Jul|
| • Re: LIKE||Paul DuBois||3 Jul|