Category "mysql-json"

MySQL JSON: How to find object from key value

I'm trying to find a way to search a JSON object and get a particular key but search on another key. Here is an example schema: CREATE TABLE `fields` ( `id`

Conditionally select values from an array in a nested JSON string in a Mysql database

I am struggling to conditionally extract values from a nested JSON string in the Mysql table. {"users": [{"userId": "10000001", "userToken": "11000000000001", "