By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT JSON_CONTAINS('["A1", "A2", "BI"]', '"A1"');
| JSON_CONTAINS('["A1", "A2", "BI"]', '"A1"') |
|---|
| 1 |
SELECT JSON_CONTAINS('["A1", "A2", "BI"]', '"foo"');
| JSON_CONTAINS('["A1", "A2", "BI"]', '"foo"') |
|---|
| 0 |