Mysql全文搜索MATCH AGAINST
super
2023-10-09 09:54

field1,field2字段类型为text,建立FULLTEXT索引

基础用法:
SELECT * FROM `article` WHERE MATCH(字段) AGAINST('搜索内容') LIMIT 1
SELECT * FROM `article` WHERE MATCH(field1,field2) AGAINST('123123') LIMIT 1
0 条讨论