full text search is different than pattern match. If
you want to return stef, you have to use pattern
match.
Qunfeng
--- "Steffan A. Cline" <[EMAIL PROTECTED]> wrote:
> Am I missing something on mysql full text search?
>
>
> I was using a simple statement like
> select firstname from contacts where
> match(firstname,lastname) against
> ('steffa');
>
> I am actually looking for "steffan" but wanted to
> see what it would return.
> Now, if I search for the full name "steffan" it
> finds it ok. Is there
> something I am missing for it to return any matches
> containing "steff" or
> "steffa" or even "stef" ????
>
>
> Thanks
>
> Steffan
>
>
---------------------------------------------------------------
> T E L 6 0 2 . 5 7 9 . 4 2 3 0 | F A X 6 0 2 . 9 7
> 1 . 1 6 9 4
> Steffan A. Cline
> [EMAIL PROTECTED]
> Phoenix, Az
> http://www.ExecuChoice.net
> USA
> AIM : SteffanC ICQ : 57234309
> The Executive's Choice in Lasso driven Internet
> Applications
>
---------------------------------------------------------------
>
>
>
>
---------------------------------------------------------------------
> 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
>
__________________________________________________
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
---------------------------------------------------------------------
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
