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*")