By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create table audits (new_values varchar(50));
insert into audits values ('{"video_status_ids": "[6, 8, 14, 29]"}')
SELECT JSON_CONTAINS(new_values, '8', '$.video_status_ids')
FROM audits
| JSON_CONTAINS(new_values, '8', '$.video_status_ids') |
|---|
| 0 |
SELECT JSON_CONTAINS(JSON_UNQUOTE(JSON_EXTRACT(new_values, '$.video_status_ids')), '8')
FROM audits
| JSON_CONTAINS(JSON_UNQUOTE(JSON_EXTRACT(new_values, '$.video_status_ids')), '8') |
|---|
| 1 |
SELECT JSON_CONTAINS(new_values->>'$.video_status_ids', '8')
FROM audits
| JSON_CONTAINS(new_values->>'$.video_status_ids', '8') |
|---|
| 1 |