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