MySQL Select Statement to joint 2 fields value into 1 return

1 min read

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

Latest from Blog