I'm using innodb full-text search to return a set of results where the newest posts are more relevant.  Just wanted to check that this the best method:SELECT *, (MATCH(note) AGAINST ('$search' IN BOOLEAN MODE))/SQRT(GREATEST(1, DATEDIFF(NOW(), date))) AS score FROM notes WHERE userid = '$userid' HAVING score > 0 ORDER BY score DESC
Weighting mysql full-text search results by date
sql;mysql