Check if an element does not exist in array #16947
Replies: 1 comment
-
You can negate the output of the function using |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have a column with arrays and value with the condition that if the value does not exist in the array, then I consider that value. Going through the documentation I found that JSON_ARRAY_CONTAINS checks if a value exists in an array. Is there any function or way to check the negative condition that the element does not exist in an array?
I believe I can separate the query into a CTE and achieve this but wanted to know if there is a direct function.
Beta Was this translation helpful? Give feedback.
All reactions