Combine Two Columns in SQL: CONCAT Guide

1 year ago
Liam
1 minute

In SQL, you can combine two columns of data into one using the CONCAT function. For example, if you have a table called users with columns first_name and last_name, and you want to combine them into a single column for a full name.

SELECT CONCAT(first_name, ' ', last_name) AS full_name
FROM users;

The mentioned SQL statement concatenates the data in the first_name and last_name columns with a space and names the result as the full_name column.

bannerAds