MySQL ambil data JSON dengan JSON_EXTRACT

Contoh sederhana

SELECT
JSON_EXTRACT(
  '{"id":123}',
  '$.id'
) chat_id;

Contoh komplek

SELECT
JSON_EXTRACT(
  '{"id":123,"alamat":{"alamat1":"Kirana Cibitung","alamat2":"Kab. Bekasi"}}',
  '$.alamat.alamat1'
) address;