JSON_EXTRACT_PATH

1
SELECT JSON_EXTRACT_PATH(
2
  '{"user": {"profile": {"name": "Budi", "city": "Jakarta"}}}',
3
  'user', 'profile', 'name'
4
) as name;

1
SELECT
2
  id,
3
  JSON_EXTRACT_PATH(data, 'config', 'settings', 'theme') as theme,
4
  JSON_EXTRACT_PATH(data, 'config', 'settings', 'language') as language
5
FROM app_configs;

1
SELECT
2
  JSON_EXTRACT_PATH('{"a": {"b": 1}}', 'a', 'b') as found,
3
  JSON_EXTRACT_PATH('{"a": {"b": 1}}', 'a', 'c') as not_found,
4
  COALESCE(
5
    JSON_EXTRACT_PATH('{"a": {"b": 1}}', 'a', 'c'),
6
    JSON('"default"')
7
  ) as with_default;