title: Matching multiple values using ARRAY_CONTAINS in Spark SQL
body: <p>I can use <code>ARRAY_CONTAINS</code> function separately <code>ARRAY_CONTAINS(array, value1) AND ARRAY_CONTAINS(array, value2)</code> to get the result. But I don't want to use <code>ARRAY_CONTAINS</code> multiple times. Is there a function to check both values presence at a time in an array.</p>