mysql全文搜索:sql的写法
<br />mysql全文搜索,sql的写法: <br />MATCH (col1,col2,…) AGAINST (expr [IN BOOLEAN MODE | WITH QUERY EXPANSION]) <br />比如: <br />SELECT * FROM articles WHERE MATCH (title,body) AGAINST (’database’); <br />MATCH()函数对于一个字符串执行资料库内的自然语言搜索。一个资料库就是1套1个或2个包含在FULLTEXT内的列
原创
2010-08-13 12:56:00 ·
694 阅读 ·
0 评论