Articles/SQL

CONCAT() in MySQL — How It Works

What the MySQL CONCAT() function does, with an example.

Published October 18, 2026

CONCAT() joins two or more strings together into one.

Key points

  • Part of standard SQL functions available in MySQL for working with text/strings

Example

SELECT CONCAT(first_name, ' ', last_name) FROM users;
More SQL articles