[SOLVED] mysql query help

[MrBillybob]

i want to select all of the data for each and every user separately using a query..is this possible?

user    t      etc
a       4      xy
a       13     gg
b       5      xx
a       43     df
c       2      xy

and then

 

i wanna get all of the data from user a, but i dont know that a == a i need to be able go throughthe database and collect all the data from a then find the next user name and get data for it...if this doesn make sense ask for more info

 

 

[beboo002]

select * from tablename;

get all the data from table

and

select columnname from table name

where columnname = 'a';

 

hope its help u

[MrBillybob]

well beboo i want to out put totals for a so i only want to get its data once then get b's data but that will get a data then a data then b...a...c

[beboo002]

select distinct(column name) from table name remove duplicacy

and

select username from table name

orderby t;