SQL String Functions

SELECT CONCAT(first_name, ' ', last_name) FROM users; # concatenate strings

SELECT LENGTH(name) FROM users; # string length

SELECT UPPER(name) FROM users; # convert to uppercase
SELECT LOWER(email) FROM users; # convert to lowercase

SELECT SUBSTRING(name, 1, 3) FROM users; # extract substring

SELECT TRIM(name) FROM users; # remove leading/trailing spaces
SELECT LTRIM(name) FROM users; # left trim
SELECT RTRIM(name) FROM users; # right trim

SELECT REPLACE(email, '@old.com', '@new.com') FROM users; # replace text