adam84 Posted February 8, 2007 Share Posted February 8, 2007 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 Quote Link to comment Share on other sites More sharing options...
artacus Posted February 8, 2007 Share Posted February 8, 2007 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. Quote Link to comment Share on other sites More sharing options...
adam84 Posted February 8, 2007 Author Share Posted February 8, 2007 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. Quote Link to comment Share on other sites More sharing options...
fenway Posted February 8, 2007 Share Posted February 8, 2007 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. Quote Link to comment Share on other sites More sharing options...
artacus Posted February 8, 2007 Share Posted February 8, 2007 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. Quote Link to comment Share on other sites More sharing options...
worldworld Posted February 10, 2007 Share Posted February 10, 2007 Please see here for details... Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.