SELECT * from `commercialold1` where 1 AND MATCH(`name`) AGAINST ('city*' IN BOOLEAN MODE) LIMIT 30,10 city) Fonte Pesquisa ligado FFonts.net como Inthacity Regula

Fontes / city) Fonte Pesquisa / (1000) 

/ city) Fonte Pesquisa

Fontes / city) Comercial