SELECT * from `commercialold1` where 1 AND MATCH(`name`) AGAINST ('rosado*' IN BOOLEAN MODE) LIMIT 0,10 rosado Polices Recherche

Polices / rosado Polices Recherche / (14) 

/ rosado Polices Recherche

Polices / rosado Commercial