comparing one variable agaisnt two mysql columns

[nozom]

I want to use a keyword search to search on the columns 'description' and 'title'. returning results if its in either one

my sql looks like this

$result=mysql_query("SELECT * FROM listing 
		WHERE listing.Description LIKE '%$_SESSION[keywords]%' AND listing.Title LIKE '%$_SESSION[keywords]%' 

that result obviously only returns the result if the keyword is in BOTH columns, if i replace the AND with an OR it goes wrong.

any ideas?
Thanks,
hugh

[LordShryku]

What do you mean by "goes wrong"?

[nozom]

i have cut that down as its a more complex query, the OR in there messes up my other WHERE clauses.

[LordShryku]

Well, since your only showing a partial of your query, my only guess would be that you should be doing this as an OR. Try adding parenthases around those two lines. Sometimes that helps.

SELECT * FROM listing  

WHERE (Description LIKE '%".$_SESSION['keywords']."%' 
OR Title LIKE '%".$_SESSION['keywords']."%')...

[nozom]

Does the job, rock on 🙂

cheers,
Hugh