>Hi Everyone, > >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? > >Much thanks, > >Eric -- Paul DuBois, [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
