SELECT * FROM different columns

newbie-question, sorry... is it possible to write this (working) query in a shorter form: SELECT * FROM $table WHERE (col1 LIKE '%$term%') OR (col2 LIKE '%$term%') OR (col3 LIKE '%$term%') thanks for your help! Reto Baudenbacher

re: SELECT * FROM different columns

On Wednesday 19 February 2003 12:51, Reto Baudenbacher wrote: newbie-question, sorry... is it possible to write this (working) query in a shorter form: SELECT * FROM $table WHERE (col1 LIKE '%$term%') OR (col2 LIKE '%$term%') OR (col3 LIKE '%$term%') The short answer - yes, you can write