Filtering on JSON Values

Filtering on JSON

Use -> or JSON_EXTRACT() in WHERE clauses to filter rows based on JSON field values.

Example

-- Find products where ram = 16
SELECT name FROM products
WHERE attributes->'$.ram' = 16;

-- Find products where ssd is true
SELECT name FROM products
WHERE JSON_EXTRACT(attributes, '$.ssd') = true;

SQL

Full Editor

Pro Tip

Without a generated column index, JSON WHERE filters do full table scans.

Related Resources

MySQL Reference

Complete tag & property list

MySQL How-To Guides

Step-by-step practical guides

MySQL Exercises

Practice what you've learned