Hi,
As of Version 4.0.1 you can use the truncation operator * in boolean mode:
select firstname from contacts where match(firstname,lastname) against
('steff*' in boolean mode);
This will match steff , steffa, steffan, steffane, steffans ....
But of course not "stef" unless you use 'stef*' .
Regards
Salam
Steffan A. Cline 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
---------------------------------------------------------------------
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
