user 1 - [{"domain_id":1},{"domain_id":2}]
user 2 - [{"domain_id":2}]
how to get all those users whose domain_id = 2,here domain_id is a json key
Asked
Active
Viewed 261 times
0
-
what does `select version();` show? – ysth Dec 13 '21 at 18:57
-
Its not clear if these JSON String are what is stored on your database or if they are how you receive the parameters to be placed in the query? Can you elaborate please – RiggsFolly Dec 13 '21 at 18:58
-
1Possible duplicate of https://stackoverflow.com/questions/55809822/ or https://stackoverflow.com/questions/58013037/ – Bill Karwin Dec 13 '21 at 19:48