mysql - 仅全文搜索列值的前 100 个字符

Question

如何在 MySQL 中执行全文搜索，仅搜索列中值的前 100 个字符？

Answer 1

创建全文索引时可以指定前缀长度

ALTER TABLE  table_name ADD FULLTEXT (
    column (100)
);

http://dev.mysql.com/doc/refman/5.0/en/create-index.html

Prefix lengths are given in characters for nonbinary string types and in bytes for binary string types. That is, index entries consist of the first length characters of each column value for CHAR, VARCHAR, and TEXT columns, and the first length bytes of each column value for BINARY, VARBINARY, and BLOB columns.