Re: Full Text Search Boolean Mode

[Matthew Caruana Galizia]

Boolean MATCH will almost always return a relevance of 1, so the following query is pointless:

SELECT id, title, MATCH(title) AGAINST ('abcd efgh' IN BOOLEAN MODE) AS score FROM table_alphabet WHERE MATCH(title) AGAINST ('abcd efgh' IN BOOLEAN MODE) ORDER BY score DESC;

To have your results sorted by relevance, you need to sort them against a natural search. Remove the first IN BOOLEAN MODE.