FullText Relevance not sorting

[leegold2]

Given the SQL shouldn't the records be sorting by score ie. relevance? I thought if "WHERE MATCH" is used it will sort that way. Thanks

mysql> SELECT `page`.`title` , MATCH ( `title` , `descrip` ) AGAINST ( '+code+nasdac' IN BOOLEAN MODE ) AS SCORE FROM `page` WHERE MATCH ( `title` , `descrip` ) AGAINST ( '+code+nasdac' IN BOOLEAN MODE );
+---------------------------------------------+-----------------+
| title | SCORE |
+---------------------------------------------+-----------------+
| Code 99 Specifications | 1.3333333730698 |
| Centralized Management System | 1 |
| Report Number Series | 1.3333333730698 |
| Reviewing Documents for Release | 1 |
+---------------------------------------------+-----------------+
4 rows in set (0.00 sec)

mysql>

 

[TonyGroves]

If you want the results in any particular order, you have to use an ORDER BY clause, in this case "ORDER BY score".