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
--
Keith C. Ivey <[EMAIL PROTECTED]>
Tobacco Documents Online
http://tobaccodocuments.org
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
