JSON_EXTRACT

1
SELECT JSON_EXTRACT('{"name": "John", "age": 30}', '$.name');

1
SELECT
2
  data -> '$.name' as name_json,
3
  data ->> '$.name' as name_text
4
FROM json_table;

1
SELECT
2
  data ->> '$.user.name' as user_name,
3
  data ->> '$.user.address.city' as city
4
FROM users;

1
SELECT
2
  data ->> '$.items[0].name' as first_item,
3
  data ->> '$.items[1].price' as second_price
4
FROM orders;