The Little Guy Posted October 5, 2009 Share Posted October 5, 2009 I would like to be able to do better search queries, I currently can't do awesome searches. I would like to make a smart search, and return relevant information. SELECT SQL_CALC_FOUND_ROWS *, MATCH(artist, song, album) AGAINST ('$q' IN BOOLEAN MODE) as score FROM mp3 WHERE MATCH( `artist`, `song`, `album` ) AGAINST ('$q' IN BOOLEAN MODE) AND `status` = '2' ORDER BY score DESC The above doesn't return the relevant information that I would like it to return. Any suggestions on how to make my search even more accurate than it is? Quote Link to comment https://forums.phpfreaks.com/topic/176606-more-accurate-search-results/ Share on other sites More sharing options...
pastcow Posted October 6, 2009 Share Posted October 6, 2009 Do you want to be able to weight each field? Or are you after features like stemming? or do you want to adjust ft_min_word_len o enable indexing of words with smaller lengths? Quote Link to comment https://forums.phpfreaks.com/topic/176606-more-accurate-search-results/#findComment-931348 Share on other sites More sharing options...
The Little Guy Posted October 6, 2009 Author Share Posted October 6, 2009 all of that would be cool, though I am not quite sure what stemming is... Quote Link to comment https://forums.phpfreaks.com/topic/176606-more-accurate-search-results/#findComment-931733 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.