Convert SQL to ElasticSearch Query
<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>