If you use the cast (json_expr AS sql_data_type) syntax, the cast function returns a value of the SQL data type that is specified by the sql_data_type parameter.

The MySQL CAST function is used to convert a value or expression from one data type to another data type. The changing of one data type to another data type is known as casting. The casting is very ...