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

Polices / royal Polices Recherche / (289) 

/ royal Polices Recherche

Polices / royal Commercial