MySQL Select Statement to joint 2 fields value into 1 return

You can use CONCAT to join 2 fields and return in 1 select statement value.

e.g

SELECT CONCAT(firstName,', ',lastName) as fullName FROM tableName

Leave A Comment?