This is my code:
Code: Select all
SELECT *, MATCH(name, about, keywords) AGAINST ('$search' IN BOOLEAN MODE) AS relevance FROM bl_cat WHERE MATCH(name, about, keywords) AGAINST ('$search' IN BOOLEAN MODE) ORDER BY relevance ASCModerator: General Moderators
Code: Select all
SELECT *, MATCH(name, about, keywords) AGAINST ('$search' IN BOOLEAN MODE) AS relevance FROM bl_cat WHERE MATCH(name, about, keywords) AGAINST ('$search' IN BOOLEAN MODE) ORDER BY relevance ASC