Mysql全文搜索MATCH AGAINST
super
2023-10-09 09:54
![views](/static/super/images/icon/evaluate-9a.png)
field1,field2字段类型为text,建立FULLTEXT索引
![](/uploads/article/20231009/1c66ac805fc2b98a7c460f9d1cc02de2.png)
基础用法:
SELECT * FROM `article` WHERE MATCH(字段) AGAINST('搜索内容') LIMIT 1
SELECT * FROM `article` WHERE MATCH(field1,field2) AGAINST('123123') LIMIT 1
0 条讨论