SELECT * from `commercialold1` where 1 AND ( 0 OR MATCH(`name`) AGAINST ('bend*' IN BOOLEAN MODE) ) LIMIT 0,10 the.bend

/ the.bend

/ the.bend