MySQL group by two columns -

i have mysql table fields id, name, address. entries have identical names different addresses; have identical addresses different names.

i want list including 1 entry @ each unique address , 1 entry @ each unique name.

if group name put results in temp table , select again , group address, want - seems complicated.

and doing "group name,address" not give me looking - include entries different combinations of name,address whereas want 1 entry each name , 1 each address. help!

there's nicer way this, , i'm making assumptions want, try this:

select name, '' address, count(address) rowcount   tablename   group name union select '' name, address, count(name) rowcount   tablename   group address