Efficient search with phrase and keywords

2

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?

    
asked by anonymous 23.07.2016 / 01:32

0 answers