using LIKE against 2 columns

[bfsog]

I am trying to check 2 columns for a particular pattern.

Here is the query in the code:

$query = "SELECT * FROM pages WHERE title LIKE '%$v%' OR desc LIKE '%$v%'"; 

The error I get:

Query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc LIKE '%testsearch%'' at line 1

I need to check the same columns, well actually 3 columns, all for the same variable value.

If I take out the OR and thereafter, it works, but I need that.

Any ideas?

[rosland]

I assume 'desc' is a column name?

If you try:
SELECT * FROM pages WHERE desc LIKE '%$v%'

...it will probably fail as well.

DESC is a reserved word, and is probably the reason your query fails.

(I ran the exact same query (only with different column names), and that worked fine.)

[bfsog]

How silly of me.. I use order by DESC a lot..

Cheers rosland