JSON_EXTRACT_PATH_TEXT

1
SELECT
2
  JSON_EXTRACT_PATH('{"name": "Budi"}', 'name') as json_result,
3
  JSON_EXTRACT_PATH_TEXT('{"name": "Budi"}', 'name') as text_result;

1
SELECT
2
  id,
3
  UPPER(JSON_EXTRACT_PATH_TEXT(data, 'user', 'name')) as name_upper,
4
  JSON_EXTRACT_PATH_TEXT(data, 'user', 'email') as email
5
FROM users_json;

1
SELECT *
2
FROM products_json
3
WHERE JSON_EXTRACT_PATH_TEXT(metadata, 'category') = 'Electronics'
4
  AND CAST(JSON_EXTRACT_PATH_TEXT(metadata, 'price') AS INTEGER) < 1000000;