title: Convert SQL to ElasticSearch Query
body: <p>I have this sql</p>
  
  <pre><code>Select * from a where a.col1 like %search_str% OR a.col2 like %search_str%  OR a.col3 like %search_str%;
  </code></pre>
  
  <p>What will be Elastic Search Query for this?</p>
  
  <p>Used this :</p>
  
  <pre><code>var query = {
        "query" =&gt; {
            "multi_match" =&gt; {
                    "query" =&gt; "#{search_str}",
                    "fields" =&gt;["col1","col2","col3"]
            }
        }
    }
  </code></pre>
  
  <p>Not Getting very accurate results.</p>