go-gorm / go-gorm/datatypes

How we can application IN statement that in SQL with JSON query?

Open
#151 0 comments 0 reactions 1 assignee Claimed by @jinzhu View on GitHub
Dominant language
Go
Stars
831
Forks
124
PR merge metrics
No merged PRs in 30d

Description

# 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
```JSON
{
"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?

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.