Combine First and Last Name as FullName MySQL

If you just want to select the full name, you can do just that:

select concat(firstname, ' ', lastname) as fullname from users