trying to create a site search

Error: Can't find FULLTEXT index matching the column list

[willis1480]

Getting this error:
Error: Can't find FULLTEXT index matching the column list

I changed my columns to be FULLTEXT index. Here is my query:
SELECT * FROM `items` MATCH (`description1`) AGAINST ('this is my test phrase') ORDER BY name ASC

[coopster]

Welcome to WebmasterWorld, willis1480.

For natural-language full-text searches, it is a requirement that the columns named in the

MATCH()

function be the same columns included in some

FULLTEXT

index in your table.

Resource:
Full-Text Search Functions [dev.mysql.com]

[willis1480]

thanks allot. I actually came across this after rereading the mysql pages. Thanks, problem solved!