Extracting JSON Values

JSON_EXTRACT

Use JSON_EXTRACT() or the shorthand -> operator to read values from a JSON column using JSONPath syntax.

Example

SELECT
  name,
  attributes->'$.color'  AS color,
  attributes->'$.ram'    AS ram
FROM products;

-- JSON_EXTRACT equivalent
SELECT JSON_EXTRACT(attributes, '$.color') FROM products;

SQL

Full Editor

Pro Tip

Use ->> (double arrow) to unquote strings: returns black instead of "black".

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned