MySQL includes a number of built-in string manipulation functions that are similar to the functions provided by Web scripting languages such as PHP. You can use these functions in both the "SELECT" ...
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 ...