php - MySQL匹配问题

Question

引用我之前的 stackoverflow post我正在尝试寻找通过以下方式发送的消息中的相似之处:

SELECT id, MATCH (content) AGAINST (content) AS score FROM pms_messages WHERE sender_id = '.$sender_id.' AND MATCH (content) AGAINST (content) AND score > 1;

我看到错误:#1210 - AGAINST 的参数不正确

我已在内容字段上设置了全文索引。来自 phpmyadmin:

 Edit    Drop   fulltext_index  FULLTEXT    No  No  content 1

我错过了什么？

Answer 1

当您收到错误消息时，请务必阅读手册，它会最快速地提供帮助:

AGAINST takes a string to search for, and an optional modifier that indicates what type of search to perform. The search string must be a literal string, not a variable or a column name.

引用号:http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html#function_match

所以你试图实现的目标是错误的。使用文字字符串而不是列名。

另请参阅11.9.5. Full-Text Restrictions^Docs ，具体来说:

• The argument to AGAINST() must be a constant string.