使用 SQL 进行排名搜索

参考 Ranked search with SQL

计算term的出现次数。

SELECT 
SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4)) 
AS Occurrences

以次数进行排序。

SELECT 
SUM(((LENGTH(Body) - LENGTH(REPLACE(Body, 'term', '')))/4) +
((LENGTH(Body) - LENGTH(REPLACE(Body, 'search', '')))/6))
AS Occurrences
FROM Posts 
GROUP BY PostId
ORDER BY Occurrences DESC