title: Clickhouse Array Field - Check if ANY of the items meets condition
body: <p>In my <strong>Clickhouse</strong> server, I have a table with an <strong>Array of Integers</strong> field:</p>
  <pre class="lang-sql prettyprint-override"><code>CREATE TABLE my_table
  (
    ...
    my_array_field Array(UInt32),
    ...
  
  )
  
  </code></pre>
  <p>Pretty simple definition.</p>
  <p>But now I want to filter the records matching a condition like this:</p>
  <p><strong>Any of the itens inside my_array_field is between 5000 and 6000</strong></p>
  <hr />
  <p>In <strong>postgres</strong> I was doing something like this:</p>
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM my_table WHERE EXISTS 
  (
    SELECT 1 FROM unnest(my_array_field) AS my_array_field WHERE my_array_field BETWEEN 5000 AND 6000
  )
  </code></pre>
  <p>But now I have the same challenge in clickhouse and need some help.</p>
  <p>Thanks in advance!</p>