CONCAT joins multiple strings into one. Essential for creating full names, addresses, and formatted output.

Basic CONCAT

SELECT CONCAT(first_name, last_name) FROM customers;

CONCAT with Separator

SELECT CONCAT(first_name, ' ', last_name) as full_name FROM customers;

CONCAT_WS (With Separator)

SELECT CONCAT_WS(', ', city, state, country) as location FROM customers;

CONCAT with Columns and Text

SELECT CONCAT('Order #', order_id, ' - $', total) as order_summary FROM orders;

CONCAT NULL Handling

-- CONCAT returns NULL if any argument is NULL

SELECT CONCAT(first_name, ' ', COALESCE(middle_name, ''), ' ', last_name) FROM users;

CONCAT for URLs

SELECT CONCAT('https://example.com/products/', slug) as product_url FROM products;

Generate CONCAT Queries

AI2sql combines text data as needed.