json_array_contains(json, value)


Query 1

presto:default> SELECT json_array_contains('[11, 12, 13]', 11) as JSON;

Result

 JSON 
------ 
 true

Query 2

presto:default> SELECT json_array_contains('[11, 12, 13]', 15) as JSON; 

Result

 JSON 
------- 
 false 
apache_presto_sql_functions.htm
Advertisements