[RESOLVED] Query Problem

endl

I have a db that I want to search through three fields. It is working but the fields can have multiple "words". It seems to be stopping at the first word and not going any farther.

Like searching for "test market" it pulls up "test" but not "market" if searched for separately.

The query I am using is:

$sql = "select blurb,business,url,description,keywords from sites WHERE keywords OR description OR business LIKE '%$search%'";

How do I get this to return any word from the search fields?

Thank you.

NogDog

$sql = "select blurb,business,url,description,keywords from sites 
WHERE CONCAT(keywords, description, business) LIKE '%$search%'";

The alternative would be 3 separate LIKE expressions OR'd together.

bradgrafelman

You could also add a fulltext index on all three columns (one single index for all columns) and use the MATCH .. AGAINST syntax to search.

endl

Thanks much. I will try it and get back to you.

endl

NogDog;10879453 wrote:
$sql = "select blurb,business,url,description,keywords from sites 
WHERE CONCAT(keywords, description, business) LIKE '%$search%'";
The alternative would be 3 separate LIKE expressions OR'd together.

That seems to work perfectly.

Thank you NogDog and thank you bradgrafelman.