thanks yogi  the out  put i want to get a single row  can u please  help  me

adinfid membername memberid adforumname   Names 
1             john                   1            inform           [1| cricket,1| bowling,2| batting] [2|football,4|foul]