If I understand this correctly, you want to exclude (from your PHP "table") those columns where the header value (column name) is '--HIDE--'.
You could do this with looping constructs in your PHP code, parsing each row in turn, looping through each field in that row and matching the corresponding value in the header values. Possible, but messy.
BY far ...
Thank god,Finally it worked out.
first I created a file named as mysql-init.txt in c drive.The file contains
Native JSON support wasn't introduced until MySQL 5.7 so you're out of luck if you're still running [the six-year-old] version 5.6.
I have to question why this is being stored as JSON in the first place.
This looks to me like perfectly normal, relational-style Data that could be stored in a conventional table structure:
create table table1
( id int ...