php_nub_qq Posted May 18, 2013 Share Posted May 18, 2013 (edited) Hello. I want to sort my query so that the text that had matched most of the keywords ends up on top and I have absolutely no idea how to do this. I just read something about fulltext indexing and stuff that I don't understand but it was said that innoDB tables cannot do this and unfortunately for me you can guess what my tables type is ( or whatever it is if it's not a type ). So can anybody help me I'm in a desperate need! Thanks to anyone reading this! Edited May 18, 2013 by php_nub_qq Quote Link to comment https://forums.phpfreaks.com/topic/278143-sort-search-results-by-relevancy/ Share on other sites More sharing options...
Barand Posted May 19, 2013 Share Posted May 19, 2013 Have a look at http://sphinxsearch.com/ SQL database indexing. Sphinx can directly access and index data stored in MySQL (all storage engines are supported), PostgreSQL, Oracle, Microsoft SQL Server, SQLite, Drizzle, and anything else that supports ODBC. Quote Link to comment https://forums.phpfreaks.com/topic/278143-sort-search-results-by-relevancy/#findComment-1431004 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.