[php_mysql] MySQL: How to compare two rows from same column

[yogi_raj_143]

Hello, 
I need some help in creating mySQL query, 

I have a database in format

Year Brand Rel
1990 ABC   5
1990 PQR   4
2000 ABC   3
2000 PQR   2


I want to display this data in format
Year Brand_ABC_Rel Brand_PQR_Rel, ie
1990        5             4       
2000        3             2       

Pls let me know the mYSQL for the same...