Optimize infix wildcard queries in MYSQL

replacing queries (WHERE LIKE '%term') to (WHERE LIKE ‘%mert’) to use
range indexing in InnoDB engine