Fulltext example not working

#1

I'm trying fulltext searching for the first time [Ver 12.22 Distrib
4.0.17, for pc-linux (i686)], but I can't figure out why the example
in the mySQL manual is *not* working.

mysql> SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('database');
Empty set (0.00 sec)

mysql> SELECT id, MATCH (title,body) AGAINST ('Tutorial')
-> FROM articles;
+----+-----------------------------------------+

Quote:

id | MATCH (title,body) AGAINST ('Tutorial') |
+----+-----------------------------------------+
1 | 0 |
2 | 0 |
3 | 0 |
4 | 0 |
5 | 0 |
6 | 0 |
+----+-----------------------------------------+

6 rows in set (0.00 sec)

What am I doing wrong?

#2

Mike Reef wrote:

Quote:

I'm trying fulltext searching for the first time [Ver 12.22 Distrib
4.0.17, for pc-linux (i686)], but I can't figure out why the example
in the mySQL manual is *not* working.

Mike,

DId you fulltext index the fields first?
Why not try this tutorial first? It'll show
you the whole deal,

http://www.zend.com/zend/tut/tutorial-ferrara1.php

It's very clear.

Lee

Quote:

mysql> SELECT * FROM articles
-> WHERE MATCH (title,body) AGAINST ('database');
Empty set (0.00 sec)

mysql> SELECT id, MATCH (title,body) AGAINST ('Tutorial')
-> FROM articles;
+----+-----------------------------------------+
| id | MATCH (title,body) AGAINST ('Tutorial') |
+----+-----------------------------------------+
| 1 | 0 |
| 2 | 0 |
| 3 | 0 |
| 4 | 0 |
| 5 | 0 |
| 6 | 0 |
+----+-----------------------------------------+
6 rows in set (0.00 sec)

What am I doing wrong?

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Fulltext example not working

mailing.database.mysql mailing.database.mysql

Fulltext example not working - 08-09-2004 , 07:59 PM

Re: Fulltext example not working - 08-15-2004 , 08:54 PM