MySQL String Functions

SELECT CONCAT_WS('-, first_name, last_name) FROM users; # concat with separator

SELECT * FROM users
ORDER BY FIELD(status, 'active', 'pending', 'inactive'); # custom order

SELECT FORMAT(price, 2) FROM products; # format number with decimals

SELECT CHAR_LENGTH(name) FROM users; # character length (UTF-8 aware)

SELECT LOCATE('@', email) FROM users; # find position of substring

SELECT REPEAT('*', 5); # repeat string