title: Sphinx query/settings similar to Like '%string%' SQL query
body: <p>I want to search for a string in Sphinx and get all documents that contains that string</p>
  
  <p>Example: search for "bot" and get the documents that contain "xbot", "robot", "botanic", etc</p>
  
  <p>Basically I want my search to have same effects as running a </p>
  
  <blockquote>
    <p>SELECT * FROM table WHERE column_name LIKE '%bot%'</p>
  </blockquote>
  
  <p>How can I do that?</p>
  
  <p><strong>Note</strong>:
  I tried to use <a href="http://sphinxsearch.com/docs/current.html#conf-min-infix-len" rel="nofollow">min_infix_len</a> but it seems that is only extends the search a little bit but not fully. So if I set conf-min-prefix-len = 2 it will match 'xbot' but not "botanic"</p>