I am using SQL on AWS and trying to detect quickly when a Json object has key-value in it. Anyone knows it? Thanks
For example:
A. {“context”:{“abc”:”123″} –> Yes
B. {“context”:{}} –> No
Note that I don’t know in advance the keys in this case
Thank you.