UPDATE dealsSET jdeal_status = CASE JSON_CONTAINS_PATH(jdeal_status, 'one', '$.trackIssues[0].attachments')  WHEN 0 THEN JSON_INSERT(jdeal_status, '$.trackIssues[0].attachments',    JSON_ARRAY(      JSON_OBJECT(        'date', "2020-01-28T12:04:42-05:00",        'file', 'yyyy.pdf'      )    )  )  ELSE JSON_ARRAY_APPEND(jdeal_status, '$.trackIssues[0].attachments',    JSON_OBJECT(      'date', "2020-01-28T12:04:42-05:00",      'file', 'yyyy.pdf'    )  )  END