On Fri, Jun 27, 2003 at 04:47:43PM -0400, Daniel Whitener wrote:
> 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?
Yes, you need to be doing a boolean full-text search to use the
operators like '*'. Your query would look like:
SELECT ID FROM emails
WHERE MATCH(h_subject, body) AGAINST ('V000*' IN BOOLEAN MODE);
Note that this requires MySQL 4.0.1 or later.
Jim Winstead
MySQL AB
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
