Query JSON Column
I'm trying to query a table where an item in a JSON column is in an array.
For example, the JSON in the column is ["1","2"] and the array to compare to is ["2","3"] - this row would therefore be returned because 2 is present.
I've tried the following but it doesn't work: .contains('JSON_column', JSON.stringify(my_array))
Any help would be much appreciated.
For example, the JSON in the column is ["1","2"] and the array to compare to is ["2","3"] - this row would therefore be returned because 2 is present.
I've tried the following but it doesn't work: .contains('JSON_column', JSON.stringify(my_array))
Any help would be much appreciated.
