You see, I know how to do it with MATCH AGAINST, but it does not recognize me numbers, for example: if I have a table: products
id | product | doors
1 | Toyota car | two
2 | Corolla | 4
if the search I did outside: "car 4 doors" the query I would use would be this:
select id, product from products where MATCH (product, description) AGAINST ('4-door cart');
But I would only show the toyota car, it does not work with numbers. Do you have an idea of how to make it work?