Search Query

[bolty2uk]

I have a seach query which will search user input from the TITLE field...

Looks like this...

$SQL = "Select * from LISTINGS WHERE TITLE LIKE '%$value%' LIMIT 1000" 

I now need to expand this so it will seacrch from additional fields (not just the TITLE field). Im just confused as to how to best construct the query..?

Thanks for any input...

[bolty2uk]

wohoo, got it..

$SQL = "Select * from LISTINGS WHERE TITLE LIKE '%$value%' || ADDRESS LIKE '%$value%' || CITY LIKE '%$value%'  LIMIT 1000"