sql - MySQL GROUP BY (if) -

edited: sorry badly asked..

i want group variable if variable equal.

i have this:

username       name       forename  jpumpkin_01    pumpkin    jack jpumpkin_02    pumpkin    jack pnice          nice       paul mpumpkin       pumpkin    michael 

i display content with:

select * ... ... 

this lists entries:

pumpkin    jack pumpkin    jack nice       paul pumpkin    michael 

"pumpkin jack" listed double. use group 'name'

... group name 

now, "pumpkin jack" listed 1 time, "pumpkin michael" in group too, , disapeared.

how can list michael?

thank answers , hints..

rgs

r

the group not conditional. can this: "select * ... ... group name, forename".