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 select query?


So I figured out how to do this.

In the first part of the SELECT, is where you would do the COLUMN_JSON portion and the COLUMN_GET is done in the WHERE section.


SELECT COLUMN_JSON(attr) as 'attribute' FROM items WHERE COLUMN_GET(attr, 'name' AS CHAR) like 'name%' ;

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.