Re: Using astrisk on select match against

[Radu Enea]

Ok, but the sentence from below show results finding words with "sanders":

SELECT user_id, first_name AS name, gender
FROM user_details
WHERE MATCH (first_name) AGAINST('sand*')


The problem is when I use the following:

SELECT user_id, first_name AS name, gender
FROM user_details
WHERE MATCH (first_name) AGAINST('*ande*')

witch must show at least word with "sanders" or "landers". But it show's zero results.