zwiebelspaetzle Posted July 29, 2008 Share Posted July 29, 2008 I would like to show users which words from their search were ignored because they were predefined stopwords, or too short, or ignored because they were too common. Is there a way to get this info from mysql for each specific search? Thanks! Quote Link to comment Share on other sites More sharing options...
cooldude832 Posted July 29, 2008 Share Posted July 29, 2008 some example of how you query is written would be helpful. Quote Link to comment Share on other sites More sharing options...
zwiebelspaetzle Posted July 29, 2008 Author Share Posted July 29, 2008 My query is written like this: SELECT col1, col2, col3, col4 MATCH (col2, col3, col4) AGAINST ('some text') AS SCORE FROM my_table WHERE MATCH (col2, col3, col4) AGAINST ('some text') Quote Link to comment Share on other sites More sharing options...
zwiebelspaetzle Posted July 29, 2008 Author Share Posted July 29, 2008 p.s. I created a full-text index on col2, col3, col4. Quote Link to comment Share on other sites More sharing options...
fenway Posted July 31, 2008 Share Posted July 31, 2008 There's a list somewhere on the mysql website... 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.