[SOLVED] Fulltext search help

[f1r3fl3x]

Hi all, 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"

 

AND how can i make it search for more than one word at a time ???

[f1r3fl3x]

Found it on the internet! If anyone has the same problem, here's the solution:

the wildcard is '*' (link) and is used in BOOLEAN MODE (link)