remove syntax in MySQL when working with int value in the array
UPDATE jsontesting
SET jsondata= (
SELECT JSON_ARRAYAGG(value)
FROM JSON_TABLE(
jsondata,
'$[*]' COLUMNS (
value INT PATH '$'
)
) AS jt
WHERE value != 7