[SOLVED] No results for FREETEXT search? (beginner)

[Ge64]

How do I get this to return some results?

 

mysql> SELECT * FROM information;
+------+-----------------------+-----------+------+---------------------+--------+---------+
| id   | tags                  | data      | type | date                | source | subject |
+------+-----------------------+-----------+------+---------------------+--------+---------+
|    0 | this,that,the other   | SOMESHIT  | NULL | 2008-05-17 16:59:49 | NULL   | NULL    |
|    1 | this,that,the other   | whatever3 | NULL | 2008-05-17 16:59:49 | NULL   | NULL    |
|    2 | bla your mouse coffee | whatever  | NULL | 2008-05-17 16:59:49 | NULL   | NULL    |
+------+-----------------------+-----------+------+---------------------+--------+---------+
3 rows in set (0.01 sec)

mysql> SELECT id,data FROM information WHERE MATCH (tags) AGAINST('your');
Empty set (0.00 sec)

mysql> 

 

This is my table according to CocoaMySQL:

 

 

Is there anything else I need to do before this works, I've never tried it before.

 

Edit: I'm using 4.1.22-log

[mezise]

'your' word is in default MySQL FULLTEXT stopword list. Check information about FULLTEXT configuration variables: ft_stopword_file, ft_min_word_len, etc. There are more restrictions for using FULLTEXT, please check relevant manual entries.

 

[Ge64]

Thanks, problem solved