On 27 Jun 2003 at 16:47, Daniel Whitener wrote:
> 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?
Sorry, my mistake. The asterisk only works in Boolean mode (which
requires MySQL 4). Try this instead:
SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST
('V000*' IN BOOLEAN MODE);
--
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]
