How to join three separate columns to a new one in SQL?

Created Sep 22, 2022 Edited Sep 22, 2022

Viewed 24

I need to merge 3 columns "FirstName", "MiddleName", "LastName" into a new "Full Name" Column. How should I do that?

mysql sql