mysql json data type

https://www.mysqltutorial.org/mysql-json/

SELECT id,location_info->'$.name' name FROM hibernet.notes WHERE location_info->'$.os'='Mac';