CODE EXAMPLE FOR SQL

how select a json value in mysql

SELECT * FROM table WHERE JSON_CONTAINS(name, '["key"]');