I have a table that has Name, Team, Week

I want to be able to select and have the result show me the Name and the Teams picked for that name. So data will look like this

Mike,Tampa,8
Mike,Buffalo,9
Tim,New England,8
Tim,Buffalo,9

I was the result to look like this

Mike,Tampa,Buffalo
Tim,New England, Buffalo.

Is this possible with a mysql select statement? Thanks,