How to Filter Low Relevance Score Results for FULLTEXT Search (score() function)

[mchangtian]

I am using Doris' FULLTEXT search feature with MATCH_ANY, and follow the official example to retrieve relevance scores via score() function. The basic search works fine, but I cannot filter out records with low relevance scores—any attempt triggers a syntax error about score() being restricted to SELECT clause only.

I want to ask:

1. Does Doris support filtering low relevance score results for FULLTEXT search?
2. If yes, what is the correct SQL syntax (based on the official demo below)?
3. If not, is there an alternative approach (without heavy performance cost like temporary tables)?

Environment Information

• Doris Version: [Output of SELECT VERSION(); 4.0.1]

I tried to filter records with relevance > 5 using the following SQL (ensuring score() is only in SELECT clause of subquery):

SELECT a.* FROM (
    SELECT *, score() AS relevance
    FROM search_demo
    WHERE content MATCH_ANY '检索测试'
) a WHERE a.relevance > 5 ORDER BY a.relevance DESC LIMIT 10;

Exact Error Message Encountered

SQL 错误 [1105] [HY000]: errCode = 2, detailMessage = score() function can only be used in SELECT clause, not in WHERE clause