How we can application IN statement that in SQL with JSON query?
MuhmdHsn313 opened this issue · 0 comments
MuhmdHsn313 commented
The Question
How we can application IN statement that in SQL with JSON query?
If I have a people table, and it has a column of JSON data type, and this column contains a key with the title age representing the age of the person, like
{
"age": 24
}How can I get people within a range of ages? i.e. how to apply IN that in SQL to a JSON stored in the database?