json_array_contains(json, value)

查询 1

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

查询 2

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

apache_presto_sql_functions.html