// your_column = [{id: 1, name: "Tom", age: 30}];
SELECT * FROM your_table
WHERE json_contains(your_column->'$[*].id', json_array("your_id_to_match"));
For further actions, you may consider blocking this person and/or reporting abuse
// your_column = [{id: 1, name: "Tom", age: 30}];
SELECT * FROM your_table
WHERE json_contains(your_column->'$[*].id', json_array("your_id_to_match"));
For further actions, you may consider blocking this person and/or reporting abuse
Bellamer -
Kyle Pena -
Duc Nguyen Thanh -
SpecialBroccoli -
Top comments (0)