No, what divinequran is actually after is a crosstab query .... unfortunately, MySQL cannot do them "natively".

Have a look at the following URL (http://rpbouman.blogspot.com/2005/10...-in-mysql.html) - there is a workaround .... a bit tedious, but possible.