title: Elasticsearch equal SQL %Like%
body: <p>Coming from <a href="https://www.elastic.co/guide/en/elasticsearch/guide/current/partial-matching.html" rel="noreferrer">here</a> i'm asking myselve for the elasticsearch syntax for such querys:</p>
  
  <pre><code>WHERE text LIKE "%quick%"
    AND text LIKE "%brown%"
    AND text LIKE "%fox%" 
  </code></pre>
  
  <p>my try (unfortunately without success)</p>
  
  <pre><code>  "query": {
      "bool": {
        "filter": [
          {
            "bool": {
              "must": [
                {
                  "terms": {
                    "text": [
                      "*quick*",
                      "*brown*",
                      "*fox*"
                    ]
                  }
                }
              ]
            }
          }
        ]
      }
    }
  </code></pre>