MySQL 5.7

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT VERSION();

VERSION()

5.7.39

DROP TABLE IF EXISTS `tbl`;
CREATE TABLE IF NOT EXISTS `tbl` (
  `id` SERIAL,
  `meta` JSON
);
INSERT INTO `tbl`
SELECT NULL, '{"options" : {"info" :  [{"data" : "data1", "verified" : 0},{"data" : "data2", "verified" : 1}]}}';

Records: 1  Duplicates: 0  Warnings: 0

SELECT `id`, (`meta` -> '$.options.info[*].data') `data`
FROM `tbl`
WHERE `meta` -> '$.options.info[*].verified' = 1;

id
data

SELECT `id`, (`meta` -> '$.options.info[*].data') `data`
FROM `tbl`
WHERE `meta` -> '$.options.info[1].verified' = 1;

id
data

1
["data1", "data2"]

SELECT `id`, (`meta` -> '$.options.info[*].data') `data`
FROM `tbl`
WHERE JSON_CONTAINS(`meta` -> '$.options.info[*].verified', '1');

id
data

1
["data1", "data2"]