MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE test (`order` JSON)
SELECT '{"id":1,"price":123}' `order`;
SELECT JSON_VALUE(`order`, '$.price') price
FROM test


price


123


SELECT JSON_VALUE(`order`, LOWER('$.price')) price
FROM test
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LOWER('$.price')) price
FROM test' at line 1