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

Polices / chandan Polices Recherche / (2) 

/ chandan Polices Recherche

Polices / chandan Commercial