mysql Match

[adam84]

I am using mysql 5.0 and I wrote a query using the MATCH function (i guess you can call it that) and I keep getting this error any ideas?

 

Table sport:

sportID              int

sportName          varchar

famousPlayers    longtext

.....

 

SELECT * FROM sport WHERE MATCH ('famousPlayer') AGAINST ('Mike');

 

MySQL said: 

 

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

 

Anyone know what that means, or how i can fix it...? thanks

 

[artacus]

1) You spelled your column name wrong

2) You either need a full text index on famousPlayers or you need to run MATCH AGAINST in boolean mode.

[adam84]

i manually typed the statement in. I made sure that it was spelt correct. What is a full text index? I have never hear dof it before.

[fenway]

MATCH... AGAINST requires a fulltext index on the indicated columns... you may want to consult the refman to review the limitations of this type of index.

[artacus]

I made sure that it was spelt correct. What is a full text index? I have never hear dof it before.

 

Silly me, I should have known that spelling wouldn't be an issue with you.

[worldworld]

Please see here for details...