php_nub_qq Posted May 18, 2013 Share Posted May 18, 2013 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! 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. 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
Archived
This topic is now archived and is closed to further replies.