fulltext indexing

[kalyan kumar]

Hi,


One of the interesting features of MySQL is Full-Text indexing.
But Full-Text indexing has Stopwords. How to avoid these stopwards.

I have tried it with BOOLEAN mode but of no use.


mysql> SELECT * FROM im_test WHERE message LIKE '%soon%';
+--------------------------------------+------------+---------------+----------------------+------------------------+
| sessionid | date | UserID | addUserId | message |
+--------------------------------------+------------+---------------+----------------------+------------------------+
| 502fe114-1efd-4b14-9958-361af17c383a | 2009-08-24 | exec@testsaas | [e-mail] | as soon as you wiil be |
+--------------------------------------+------------+---------------+----------------------+------------------------+


mysql> SELECT * FROM im_test WHERE MATCH (message) AGAINST ('soon' IN BOOLEAN MODE);
Empty set (0.00 sec)


Is there any way to search these words too.

Please help me.


Thanks,
Kalyan.



Edited 1 time(s). Last edit at 08/24/2009 11:05AM by kalyan kumar.