Using astrisk on select match against

[Radu Enea]

Hello,

I have the following code that should select all strings that contain "ous" in first_name column (like house, etc).


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


The problme it's shows me zero results. In first_name column I have a lot of words with "house". first_name column have Fulltext assign.

If I use just "...AGAINST ('hou*')" it return all first_name containing "house" witch is ok.

I can't use two astrisk in the sentence ?

Thank you