SELECT MATCH (name) AGAINST ('+salon selective* conditioner*' IN BOOLEAN MODE) as score, cubecart_inventory_widget_one.* FROM cubecart_inventory_widget_one WHERE MATCH (name) AGAINST ('+salon selective* conditioner*' IN BOOLEAN MODE) order by score DESC