JSON_VALID

1
SELECT
2
  JSON_VALID('{"name": "John"}') as valid_json,
3
  JSON_VALID('not a json') as invalid_json,
4
  JSON_VALID('[1, 2, 3]') as valid_array;

1
SELECT *
2
FROM raw_data
3
WHERE JSON_VALID(json_column);

1
SELECT
2
  COUNT(*) as total,
3
  SUM(CASE WHEN JSON_VALID(metadata) THEN 1 ELSE 0 END) as valid_count,
4
  SUM(CASE WHEN NOT JSON_VALID(metadata) THEN 1 ELSE 0 END) as invalid_count
5
FROM products;