Move GROUP_CONCAT's comma values to columns

[Jassim Rahma]

Hi, I am using below code to display times as Pivot table grouped by date, this is basically for fingerprint attendance... I am getting what I want like this: 2012-06-03 10:23:30,10:23:32,10:24:05,10:24:07,10:24:24,10:24:26 How can I make the comma separated values displayed in columns instead of comma so it will be something like this created_date --- time1 --- time2 --- time3 --- time4 --- etc this is the code:

SELECT created_date, GROUP_CONCAT(created_time)
FROM fingerprint
GROUP BY created_date

Technology News @ www.JassimRahma.com