CAST data to JSON type

This converts valid json strings to MySQL JSON type:

SELECT CAST('[1,2,3]' as JSON) ;
SELECT CAST('{"opening":"Sicilian","variations":["pelikan","dragon","najdorf"]}' as JSON);

Found a mistake? Have a question or improvement idea? Let me know.

Table Of Contents