How to get MYSQL JSON object value when don't know the key?

Question

I have a column in MYSQL table from which I want to get object's first value, and I don't know what is the kay name. Values are like:

{"5":"ABC"} 
{"8":"CDE"}

I have tried JSON_EXTRACT, JSON_KEYS but nothing work for me.

score 3 · Accepted Answer · answered Jul 17 '20 at 13:02

3

Below query worked for me:

SELECT json_extract(json_data,'$[0].*') from table

For detailed documentation, go through JSON_EXTRACT once.

answered Jul 17 '20 at 13:02

Ankit Jindal

Thanks @Ankit, Following query is working for me. `SELECT JSON_UNQUOTE(JSON_EXTRACT(JSON_EXTRACT(sender_id, '$[0].*'), '$[0]')) FROM table` – Anand agrawal Jul 17 '20 at 14:32
Great!! @Anandagrawal – Ankit Jindal Jul 17 '20 at 15:15

1 Answers1