Dragoon Posted May 21, 2007 Share Posted May 21, 2007 I've been working on a simple search engine (for no particular reason), and I've run into a problem. I'd like to be able to search for multiple words, and have it return any results in which a certain field contains all or any of those words in any order. So, if I search for "example one" it would return things that contained "one example" and "one other example as well as the exact phrase, or ones that only contain some of the words in the query ("example two"). Ideally, it should also give each result a rank based on how closely they match the query, and list them in order of relevance. Anyone have any idea how this could be done? Quote Link to comment https://forums.phpfreaks.com/topic/52280-solved-mysql-queries-and-relevance/ Share on other sites More sharing options...
Barand Posted May 21, 2007 Share Posted May 21, 2007 http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html Quote Link to comment https://forums.phpfreaks.com/topic/52280-solved-mysql-queries-and-relevance/#findComment-257942 Share on other sites More sharing options...
Dragoon Posted May 22, 2007 Author Share Posted May 22, 2007 http://dev.mysql.com/doc/refman/4.1/en/fulltext-search.html Thanks, that worked perfectly. Quote Link to comment https://forums.phpfreaks.com/topic/52280-solved-mysql-queries-and-relevance/#findComment-258778 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.