The problem of full-text MySQL MySQL

Question

I have a database named "products" and a FULLTEXT index with the columns: titleand description. All my products are lubricants (oils), and there are two types of them: industrial and auto-moto, with a speed of 55-45%. If I do a search after auto-moto oil, it will not return any results, because the keyword "auto-moto" is present in more than half of the lines, and the oil is in all of them, so MySQL puts them in the STOPWORDS list.

I am using PHP. How can I make this query to return the correct results?

Answer 1

IN BOOLEAN MODE. , mysql , 50% . : AGAINST ('*key*').

Answer 2

, , auto-moto "-", http://dev.mysql.com/doc/refman/5.0/en/fulltext-boolean.html NOT, "", "moto"

"auto moto"

SQL, , .