stored procedures - Mysql select only column has data -

I would like to select only columns that contain data in mysql only.

For example, I have follwing as table 1:

  Table 1 name VAL1 Val 2 Val 3 Val 4 A1 2B2 3C3 3   
 name, val 1, wall 2, wall 3, table 1 to val4;  
 How can I select only names, val1, val2 in mysql?  
  Results: Table 1 Name VAL1 VAL2 A1 2B2 3C3 3   
 Regards   
 
 
 You can not predict the value and value you are trying to achieve, because you can not predict that statement How many columns will be to execute  NULL   earlier .  
 Although there are many easy ways in PHP or other languages, organize your results according to your needs.