is it possible to do the following ?
table has ID,number,column1,column2,column3,column4
i need to select a column by the value in the number column
eg results would be
eg if number =1 then select column1, number=2 select column2 etc
thanks in advance