Searching MySQL

[sparc20]

Im trying to search a MySQL DB but i get the following error instead:

Error

SQL-query :

SELECT * ,
MATCH (

introduction
)
AGAINST (
'NASA'
) AS SCORE
FROM project_stories
LIMIT 0 , 30

MySQL said:


#1191 - Can't find FULLTEXT index matching the column list



Anyone knows whats going ?

 

[r937]

um, did you create a FULLTEXT index?

rudy

http://r937.com/

SQL Consulting

 

[sparc20]

I have yes, all columns are text and are indexed as fulltext. the funny thing is it that the query
runs for seperate columns:i.e. title,introduction,body_text

SELECT *,
MATCH(title) AGAINST...

but when the query is combined with the other 2 columns

SELECT *,
MATCH(title,introduction,body_text) AGAINST...


returns that error above