Thanks for the quick reply! Actually I read through that page before and I tried it and still nothing....
mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*'); Empty set (0.00 sec)
any good reason why that wouldn't work?
Thanks again,
Daniel
Keith C. Ivey wrote:
On 27 Jun 2003 at 16:30, Daniel Whitener wrote:
an example of this string is V000111121 - they all start with v000
[snip]
mysql> select ID from emails where body like '%v000%';
[snip]
mysql> SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('v000');
Full text searching searches by word, not by pieces of a word. If the word is 'V000111121' you won't find it by searching for 'V000'.
You can, however, use an asterisk at the end for a wildcard:
SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*');
Read the documentation here:
http://www.mysql.com/doc/en/Fulltext_Search.html
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]