At 13:53 +0200 2001-06-26, Bruce Stewart wrote:
If you searched for '% john %' - note the spaces, you would not find
'johnson' etc..
*Sigh* Since when do wildcards work with the fulltext index?
Besides, there are characters beside a space wich can delimit words.
Three examples: Commas. Line breaks. The start of the actual data. If
you really want words, use "rlike" and \<...\> (assuming that MySQL
can do egrep-like escapes). But it'll be dirt slow compared to the
fulltext index.
--
Matthias Urlichs
---------------------------------------------------------------------
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