CONCAT

The CONCAT function in SQL is used to join (concatenate) two or more strings into a single string.

Basic Usage

SELECT CONCAT('Hello', ' ', 'World');

Result:

Hello World

Concatenating Columns

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

• Joins first_name and last_name with a space in between.
• The result is aliased as full_name.

Multiple Arguments

• CONCAT can take two or more arguments.
• If any argument is NULL, the result is NULL (in some databases like MySQL).

Database Differences

• MySQL, MariaDB: Use CONCAT().