I'm using the following syntax in SQL for searches:
SELECT * FROM exemplo WHERE MATCH(title,content,tag) AGAINST(?)
Regarding LIKE I had a better result, but it's still not 100%.
For testing purposes, I have a title-only record with the other empty fields, like this:
I see car a little kneaded on the sides of year 2002
And I do the following search:
Buy car of the year 2002;
But the result is false, what can I do to make the search more efficient and list as many words as possible even if they are not side by side?