How do you use COLUMN_JSON with COLUMN_GET on dynamic columns in MariaDB?
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.

Example;

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