WHERE * LIKE

So, when I run a query like:

SELECT * FROM table_name WHERE column1 LIKE "%term%";

It normally works -- however, when I use two columns -- such as:

SELECT * FROM table_name WHERE column1, column 2, column3, column4 LIKE "%term%"; -- it blows up in my face.

Any reason why?

Guido

Because that is not proper SQL.
This is:
SELECT *
FROM table_name
WHERE column1 LIKE '%term%'
OR column2 LIKE '%term%'
OR column3 LIKE '%term%'

Worked! You the man.

Now the tricky part in getting the results to look good -- they're call clumped up now -- they display all the called columns in a clump!

Regards,

Guido