用于通过相关性排序来搜索多个标签的SQL查询

SELECT *,
       (CASE
           WHEN '标签1' IN tags THEN 1
           ELSE 0
        END
        + CASE
              WHEN '标签2' IN tags THEN 1
              ELSE 0
          END
        + CASE
              WHEN '标签3' IN tags THEN 1
              ELSE 0
          END) AS relevance_score
FROM your_table
WHERE '标签1' IN tags OR '标签2' IN tags OR '标签3' IN tags
ORDER BY relevance_score DESC;