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