0

Here is solution to the problem:

SELECT DISTINCT JSON_UNQUOTE(JSON_EXTRACT(color, '$.label')) AS label from yourtable-- (get distinct value under Jason data with in a field)

SELECT DISTINCT JSON_UNQUOTE(JSON_EXTRACT(color, '$.label')) AS label from yourtable

AM Shah
  • 1
  • Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. – Community May 15 '23 at 14:09

0 Answers0