hi Sorry for this newbie-question:
is it possible to simplifiy the following (working) query? "SELECT * FROM mytable WHERE ((col1 LIKE '%test%') OR (col2 LIKE '%test%') OR (col3 LIKE 'test%')) AND (col5 = 'y' OR col6 = 'y' OR col7 = 'y') ORDER BY col1" Thanks for any suggestions! Reto Baudenbacher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
