Use "%" instead of "*"
cheers
--
sherzodR
On 26 Nov 2001, Harald Fuchs wrote:
>According to the manual, section "New Features of Full-text Search to
>Appear in MySQL 4.0":
>
>* `*' is a truncation operator.
>
>The query
> SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versailles')
>returns 2, but
> SELECT COUNT(*) FROM documents WHERE MATCH(txt) AGAINST ('Versaill*')
>returns 0 on MySQL 4.0.
>
>Is this a bug, or do I misunderstand the meaning of "truncation"?
>
>---------------------------------------------------------------------
>Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php