Hello,
I have the following code that should select all strings that start with "rog" (like rogers, etc).
SELECT
user_id,
first_name AS name,
gender
FROM
user_details
WHERE
MATCH (first_name) AGAINST('rog*')
The problme it's that shows me zero results. In first_name column I have a lot of words with "rogers".
first_name column have Fulltext assign.
If I use just "...AGAINST ('rogers')" it return corect data.
It's something wrong with my sentence?
Thank you