// your_column = [{id: 1, name: "Tom", age: 30}];
SELECT * FROM your_table
WHERE json_contains(your_column->'$[*].id', json_array("your_id_to_match"));
Ashwani Singh
Posted on
Extract Array of object data in MySql DB
For further actions, you may consider blocking this person and/or reporting abuse
Top comments (0)