[RESOLVED] PHP MYSQL -> Searching Multiple Columns

[Sops21]

I'm trying to create a search, this is my current search query:

$query="SELECT *, MATCH (description) AGAINST ('$searchstring') AS 'score' FROM store WHERE MATCH(description) AGAINST('$searchstring' IN BOOLEAN MODE)ORDER by score DESC ";

The column is called "description" I also want to try and search a column called "name" and "address".

I've tried this:

$query="SELECT *, MATCH (description) AGAINST ('$searchstring') AS 'score' FROM store WHERE MATCH(description,address) AGAINST('$searchstring' IN BOOLEAN MODE)ORDER by score DESC ";

But it errors out..

Any ideas?

[bradgrafelman]

Add the name and address columns to both MATCH() statements, and alter the full text index to include all 3 columns (not 3 separate indexes - one index that encompasses all 3 columns).

[Sops21]

Yep, that was it. I wasn't adding all the columns to the same full text index.
Thanks for your help