关于全文检索,请大伙来聊聊,mySql如果做全文检索
JSP+mysql
JSP+mysql
解决方案 »
- 同时发5个查询语句给mysql,查询速度明显比同时1个查询慢
- mysql乱码问题的解决方法
- 字符串指定位置不含某字符的表示方法?
- 想做个在线会计系统 类似有商网 改怎么建数据库和表
- 这条SQL语句怎么优化?并请说明理由哦!呵。谢谢!
- 请高手们帮忙看这样一条语句。
- 能否在select 中加入一個統計row的信息呢?
- mysql+tomcat 怎样连接啊???
- 像concat(str1,str2,...)这样可以支持任意个参数是如何定义的?
- mysql left join 关联查询很慢
- 我们公司用的是MySQL+.NET,运行一段时间以后,总是出现超过最大连接池,这样网站就报错了,怎么回事?怎么解决?
- xampp 关于异常显示mysql未激活的问题
-> id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
-> title VARCHAR(200),
-> body TEXT,
-> FULLTEXT (title,body)
-> );
Query OK, 0 rows affected (0.00 sec)mysql> INSERT INTO articles (title,body) VALUES
-> ('MySQL Tutorial','DBMS stands for DataBase ...'),
-> ('How To Use MySQL Well','After you went through a ...'),
-> ('Optimizing MySQL','In this tutorial we will show ...'),
-> ('1001 MySQL Tricks','1. Never run mysqld as root. 2. ...'),
-> ('MySQL vs. YourSQL','In the following database comparison ...'),
-> ('MySQL Security','When configured properly, MySQL ...');
Query OK, 6 rows affected (0.00 sec)
Records: 6 Duplicates: 0 Warnings: 0mysql> SELECT * FROM articles
-> WHERE MATCH (title,body)
-> AGAINST ('database' IN NATURAL LANGUAGE MODE);
+----+-------------------+------------------------------------------+
| id | title | body |
+----+-------------------+------------------------------------------+
| 5 | MySQL vs. YourSQL | In the following database comparison ... |
| 1 | MySQL Tutorial | DBMS stands for DataBase ... |
+----+-------------------+------------------------------------------+
2 rows in set (0.00 sec)
-> WHERE MATCH (title,body)
-> AGAINST ('database' IN NATURAL LANGUAGE MODE);
那么,如果我的表里面,在title这一列也有database这个字串,这个查询语句也会把它查出来吗?