is it possible to use the '%' in a match .. against statement?
I keep getting resultsets with only whole-word matches, for example
the statement
select * from table_x where match(field_y) against ("%multi%");
does not give back the rows where field_y
(which is a TEXT field with a FULLTEXT index)
contains the word "multitasking"
why????
mfg
Walter Pachl
mailto:[EMAIL PROTECTED]
Tel: +43-1-961 01 20
Fax: +43-1-961 01 21
A-1040 Wien, Margaretenstra?e 45
---------------------------------------------------------------------
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
