Sql functions
From wikinotes
Text Functions
CONCAT
CONCAT lets you combine columns into one
SELECT CONCAT(first_name, " ", last_name) AS fullname FROM users;SUBSTRING_INDEX
SUBSTRING_INDEX lets you split/tokenize a string
SELECT SUBSTRING_INDEX('www.mysql.com', '.', 2) ##> www.mysql