Questions tagged [json-search]

I just try to get path of value using JSON_SEARCH function: SELECT JSON_SEARCH('[12, 13, {"12": 123}]', 'one', '123', null, '$[*]') path; When I run this query in MariaDB it works and I got desired result +===========+ | path | +===========+ |…

notice [ { "date": "2022. 10. 16.", "type": 3, "title": "friend", "content": "JJ friend", "parameter": "test" }, { "date": "2022. 10. 16.", "type": 3, "title": "friend", "content": "testtest friend", …

I have a table with JSON data like this: {"entries": [{"color": "blue", "value": 15, "name": "john"}, {"color": "red", "value": 30, "name": "doe"}]} I need to remove the object in the array that has value x. The code I have so far is: SELECT…

Here is my json data: { "TransactionId": "1", "PersonApplicant": [ { "PersonalId": "1005", "ApplicantPhone": [ { "PhoneType": "LANDLINE", "PhoneNumber": "8085063644", "IsPrimaryPhone": true …