By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE `projects` (
`project_ids` json DEFAULT NULL
) ENGINE=InnoDB;
INSERT INTO `projects` (`project_ids`)
VALUES
('[1, 2, 3]'),
('[1, 2]'),
('[2]'),
('[1]'),
('[2, 3]');
Records: 5 Duplicates: 0 Warnings: 0
SELECT *
FROM projects
WHERE JSON_CONTAINS(project_ids, '[1]') OR
JSON_CONTAINS(project_ids, '[2]')
| project_ids |
|---|
| 5b312c20322c20335d |
| 5b312c20325d |
| 5b325d |
| 5b315d |
| 5b322c20335d |
SELECT *
FROM projects
WHERE JSON_OVERLAPS(project_ids, '[1,2]')
| project_ids |
|---|
| 5b312c20322c20335d |
| 5b312c20325d |
| 5b325d |
| 5b315d |
| 5b322c20335d |