String Functions
function
Built-in MySQL string manipulation functions for transforming and extracting string data.
Syntax
CONCAT() SUBSTRING() UPPER() LOWER() TRIM() LENGTH()
Example
sql
SELECT CONCAT(first_name, ' ', last_name) AS full_name FROM users;
SELECT UPPER(name), LOWER(email) FROM users;
SELECT SUBSTRING(description, 1, 100) AS excerpt FROM posts;
SELECT TRIM(' hello '); -- 'hello'
SELECT LENGTH('Hello'); -- 5
SELECT REPLACE(phone, '-', ''); -- remove hyphens
SELECT LPAD(id, 6, '0') FROM orders; -- 000042