Here's the pseudo-code I'm trying to do:

```
update msa_list_copy 
select group_concat(distinct msa_name separator ', ') as concat_msa_name
group by msa

```

My table `msa_list_copy` has two columns...msa and msa\_name. I'm trying to concatenate msa\_names that share the same msa (number) and save this value in a (currently empty) third column `concat\_msa\_name, but I can't quite get it right.