I want to search for specific values in a json object, but can't use json_textcontains.
So for example we have this json_object in a column:
{
"key1" : "test",
"key2" : "test2",
"key3" : "35",
"key4" : "3.4",
"key5" : "35"
}
Now i have a search term e.g. 35 and want to get all key/value Pairs that contain this term.
-> "key3" : "35"
-> "key5" : "35"
What would be a sql statement, that is equivalent to this json_textcontains statement:
select * from T t where JSON_TEXTCONTAINS(t.jsoncolumn, '$', '35')