How do you use COLUMN_JSON with COLUMN_GET?

When I do the following query;

SELECT name, COLUMN_GET(attr, 'appearance' as char) as 'attributes' from items;

I see the 2 columns including the blob data with the weird formatting. Is it possible to include the COLUMN_JSON function to format the data inside of the that select query?