I have a table with a JSON column. The JSON column holds for each row, a JSON array with JSON objects such as this [{"my_value": 42, "category": "A"}, {"my_value": 100, "category": "C"}, {"my_value": 15, "category": "B"}, {"my_value": 123, "category": "D"}]…
The JSON data is as follows: I would like to count how many times each element in a collection, such as {"3467562849402896", "3467562861985809", "3465044211793921"}, has been used. The number of elements in the collection is not fixed and is an…
using Mysql with the following table: CREATE TABLE participants ( id INT AUTO_INCREMENT PRIMARY KEY, puuid CHAR(36) NOT NULL, data JSON, project INT GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(data, '$.project'))) STORED NULL, schoolCode VARCHAR(255) GENERATED ALWAYS AS (JSON_UNQUOTE(JSON_EXTRACT(data, '$.schoolCode'))) STORED, UNIQUE KEY…
I have a table with 1 column and rows like - Row- {'category': ['mobiles'], 'specs': ['4g', '2gb ram']} Row- {'category': ['computer'], 'specs': ['2gb ram']} I want to flatten the data into 2 columns- category, mobiles specs, 4g specs, 2gb ram…
I have 2 tables: Users table id | groups | --------------- 1 | ["1","2"] | 2 | ["2"] | Groups table id | name | ----------- 1 | Test | 2 | Jest | I need to fetch the records…
What is the best/proper way to prepare a dynamic MySQL JSON selector for queries, in order to prevent SQL injection? As an example, say I want to execute the following query: SELECT `key` ->> "$.key.path" AS `setting_value` FROM `settings` LIMIT…
Lets say i have json column as JSON_COLUMN in which i am storing the data in below format Table structure: (2 columns only) ID - Autoincrement JSON_COLUMN - Varchar2(1000) Sample Data: ID : 1 JSON_COLUMN : [ { "Name":"Number", "Id":"PhoneNumber",…
I got three data in MySQL [{"key": "field_1", "value": "test_1"}, {"key": "field_2", "value": "test_2"}] [{"key": "field_1", "value": "1"}, {"key": "field_2", "value": "test_2"}] [{"key": "field_2", "value": "test_2"}, {"key": "field_1", "value": "test_1"}] I need to search data which include "key" = "field_1"…
I have the following data and MySQL table : CREATE TABLE my_tbl( id INT, dataset_query longtext ); INSERT INTO my_tbl(id, dataset_query) VALUES (1, '{"database":1,"native":{"query":"SELECT * FROM view_1.device","template-tags":{}},"type":"native"}'); INSERT INTO my_tbl(id, dataset_query) VALUES (2, '{"database":1,"native":{"query":"SELECT id, name FROM view_1.request","template-tags":{}},"type":"native"}'); INSERT INTO…
I Have one table i.e discount_details. I have 2 columns are the ID , DiscountTotal. I want to sum the each record line total json object with in the D array (64,10,10 are the 1st record values) . Like here…