Sphinx query/settings similar to Like '%string%' SQL query -
    i want search string in sphinx , documents contains string   example: search "bot" , documents contain "xbot", "robot", "botanic", etc   basically want search have same effects running      select * table column_name '%bot%'    how can that?   note : tried use min_infix_len  seems extends search little bit not fully. if set conf-min-prefix-len = 2 match 'xbot' not "botanic"          try using wildcard in extended query syntax  , min_infix_len enabled   select * myindex match("bot | bot* | *bot*")