在MySQL中将多个文本字段合并为一个字段

I have a list of users in a table, with separate fields for first, middle, and last name. For various reasons, I need to change the database structure such that there is only one "name" field. What is the best/easiest way to migrate my data from the 3 old fields into my one new field?I have a list of users in a table, with separat