By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE test
SELECT 2 id, CAST('[1, 2, "asd", true]' AS JSON) array_test
UNION ALL
SELECT 3, '{"0": "false", "1": "one"}'
UNION ALL
SELECT 4, '[1, 3, "qwe", false]';
SELECT id, CAST(array_test AS CHAR) array_test
FROM test;
Records: 3 Duplicates: 0 Warnings: 0
| id | array_test |
|---|---|
| 2 | [1, 2, "asd", true] |
| 3 | {"0": "false", "1": "one"} |
| 4 | [1, 3, "qwe", false] |
SELECT id, CAST(array_test AS CHAR) array_test
FROM test
WHERE JSON_OVERLAPS(array_test, CAST('[2]' AS JSON));
| id | array_test |
|---|---|
| 2 | [1, 2, "asd", true] |