I'm searching through my database (version 4.0.13) looking for certain strings that start with - v000 - but the fulltext index doesn't seem to be indexing that string of letters/numbers. If I do a normal WHERE LIKE, it shows me what I need, but when I try and use the fulltext index, it gives me nothing.
an example of this string is V000111121 - they all start with v000
Using the WHERE LIKE is OK for now, but this database is only two days old and already the query takes more than 3 seconds. In a few weeks it will be crawling. I would really like to get that string indexed so I don't miss my lunch break searching for it. Any help on how I can encourage the database to index this? or is fulltext not a good type of index for my situation? BTW, the "body" field that I'm searching on is a TEXT field.
mysql> select ID from emails where body like '%v000%'; +------+ | ID | +------+ | 361 | | 494 | | 499 | | 741 | | 1969 | | 2005 | | 2495 | | 2846 | | 2852 | | 4637 | | 5051 | | 6380 | +------+ 12 rows in set (3.35 sec)
mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('v000');
Empty set (0.00 sec)Any help is greatly appreciated! I can provide more info upon request.
Sincerely,
Daniel
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
