mysql - My SQL全文搜索在搜索多列时出错

Question

我在我的问题数据库附加图像中使用以下查询:

SELECT *, MATCH(question,short_answer,long_answer) AGAINST('transmission impairment') AS Score
FROM questions
WHERE MATCH(question,short_answer,long_answer) AGAINST('transmission impairment')
ORDER BY score DESC;

我收到以下错误 :

Answer 1

以下代码对我有用:

SELECT *, MATCH(long_answer) AGAINST('guided media') AS Score FROM questions WHERE id IN (SELECT id FROM questions WHERE MATCH(long_answer) AGAINST('guided media') UNION SELECT id FROM questions WHERE MATCH(question) AGAINST('guided media') ) ORDER BY score DESC

我仍然不认为这是最佳解决方案