首页 相关文章 MySQL全文搜索之布尔搜索

MySQL全文搜索之布尔搜索

  利用IN BOOLEAN MODE修改程序, MySQL 也可以执行布尔全文搜索:

mysql SELECT * FROM articles WHERE MATCH (title,body)
  - AGAINST ('+MySQL -YourSQL' IN BOOLEAN MODE);
+----+-----------------------+-------------------------------------+
| id | title         | body                |
+----+-----------------------+-------------------------------------+
| 1 | MySQL Tutorial    | DBMS stands for DataBase ...    |
| 2 | How To Use MySQL Well | After you went through a ...    |
| 3 | Optimizing MySQL   | In this tutorial we will show ....[ 查看全文 ]

2016-02-19 标签:

MySQL全文搜索之布尔搜索的相关文章

手机页面
收藏网站 回到头部