mysql - MySql 中的全文搜索索引？

Question

我正在使用全文搜索索引编写查询，这是对还是错。

SELECT sum(p_bi.iQty)
FROM patientbillitem p_bi, patientbillpayment p_b
WHERE Match(p_bi.vItemCode) Against( 'pbi.vItemCode')

pbi.vItemCode 是单独的表列，将其视为字符串，这是否正确？

Answer 1

作为 MySQL 文档 match() ... against() ...说:

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 string value that is constant during query evaluation. This rules out, for example, a table column because that can differ for each row.

这意味着您的查询将在 p_bi.vItemCode 字段中搜索 'pbi.vItemCode' 的字符串文字，而不是搜索pbi.vItemCode 字段的内容。