MySQL全文搜索的问题 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

MySQL全文搜索的问题

MySQL全文搜索的问题# Database - 数据库

L*r2008-01-09 08:01

1 楼

在一段文本域中找同时出现的俩单词，发现website上介绍的办法
http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
#
'+apple +juice'
Find rows that contain both words.
不灵
==============
mysql>SELECT id FROM reviews WHERE MATCH (data) AGAINST ('+apple +juice');
...........
...........
| 4715432 |
+---------+
1400 rows in set (2.22 sec)
mysql> SELECT * FROM reviews WHERE id=4715432;
+---------+--------------------------------+----+
| id | data | N1 |
+---------+--------------------------

B*g2008-01-09 08:01

2 楼

don't know much about mysql.
but when I do oracle/.net/others, if I copy the code from reliable source
not work in my environment, the first thing I do is check the version diff.
For your case, make sure you use mysql 5.0

【在 L******r 的大作中提到】

: 在一段文本域中找同时出现的俩单词，发现website上介绍的办法
: http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html
: #
: '+apple +juice'
: Find rows that contain both words.
: 不灵
: ==============
: mysql>SELECT id FROM reviews WHERE MATCH (data) AGAINST ('+apple +juice');
: ...........
: ...........

a*s2008-01-09 08:01

3 楼

It seems fulltext index introduced in MySQL 5.0 and can only be used for
myisam type table.
At least, you should add the fulltext index when you create the table.

【在 L******r 的大作中提到】