Concat First Name And Last Name with ID in SELECT Statement

Concat first name and last name with ID in SELECT statement MySQL

» PHP

SELECT id, CONCAT(firstname, ' ', lastname) AS fullname FROM `$table` ORDER BY id DESC

You need to login to do this manipulation!