This page shows you the most commonly used MySQL string functions that allow you to manipulate character string data effectively. CONCAT Concatenate two or more strings into a single string. CONCAT_WS ...

SELECT birth_date, SUBSTRING (birth_date,1,4) as birth_year FROM employee_demographics; #We can also use replace SELECT REPLACE (first_name,'a','z') FROM employee_demographics; #Next we have locate - ...