eyaleyal Posted January 5, 2009 Share Posted January 5, 2009 Hello, I have articles in my website. Each article has title and content. I also have a search page to search my articles. So currently whenever someone is searching I use the following query (PHP + MySQL): ($keywords = the search keywords) SELECT * FROM articles WHERE title LIKE '%$keywords%' OR content LIKE '%$keywords%' My question is how do I show first in the list (ORDER BY) results that has the keywords in the title and only after that results that has the keywords in the content? Thanks! Link to comment https://forums.phpfreaks.com/topic/139507-very-simple-question-about-searching/ Share on other sites More sharing options...
fenway Posted January 5, 2009 Share Posted January 5, 2009 To get match rankings, you either need to use a full-text index (built-in or sphinx) or roll-your-own. Link to comment https://forums.phpfreaks.com/topic/139507-very-simple-question-about-searching/#findComment-729842 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.