title: Using like operation in SOLR
body: <p>I am using SOLR search engine. </p>
  
  <p>Few days back i came up with requirement for performing like operation on a given column.</p>
  
  <p>Eg: </p>
  
  <pre><code>Column name: Name
  
  Content: Stackoverflow is good.
  </code></pre>
  
  <p>Query is</p>
  
  <pre><code>Name:("*overflow is*")
  </code></pre>
  
  <p>This query should give me specific
  <strong>"Stackoverflow is good."</strong> as a result</p>
  
  <p>This input parameter should be considered as a whole input. It should not be considered as a Free text search. It should work as 'like' operation in SQL.</p>
  
  <p>For that iam using this configuration.</p>
  
  <pre><code>&lt;fieldtype class="solr.TextField" name="string_wildcards" positionIncrementGap="100"&gt;
        &lt;analyzer type="index"&gt;
          &lt;tokenizer class="solr.StandardTokenizerFactory"/&gt;
          &lt;filter class="solr.StandardFilterFactory"/&gt;
          &lt;filter class="solr.LowerCaseFilterFactory"/&gt;
          &lt;filter class="solr.TrimFilterFactory" /&gt;
          &lt;filter class="solr.EdgeNGramFilterFactory" minGramSize="2" maxGramSize="15"/&gt;
        &lt;/analyzer&gt;
        &lt;analyzer type="query"&gt;
          &lt;tokenizer class="solr.StandardTokenizerFactory"/&gt;
          &lt;filter class="solr.StandardFilterFactory"/&gt;
          &lt;filter class="solr.LowerCaseFilterFactory"/&gt;
          &lt;filter class="solr.TrimFilterFactory" /&gt;
          &lt;filter class="solr.KeywordTokenizerFactory"/&gt;
        &lt;/analyzer&gt;
      &lt;/fieldtype&gt;
  </code></pre>
  
  <p>This query is not giving me result as expected from 'like' operation.</p>
  
  <p>Eg:  Name:("<em>overflow is</em>") </p>
  
  <p>would search as FREE TEXT and not like 'LIKE' operator.</p>
  
  <p>It gives me result as </p>
  
  <ol>
  <li>What is overflow.</li>
  <li>My name is ABC</li>
  <li>What is overflow</li>
  <li>Stackoverflow is good.</li>
  </ol>
  
  <p>My expected result is only point 4, where as above configuration gives me all 4 results, which is wrong.</p>
  
  <p>Kindly help me with correct configuration for my requirement.</p>