concat
Description
Syntax:
VARCHAR concat (VARCHAR,...)
This function concatenates multiple strings. If any of the arguments is NULL, it will return NULL.
Example
mysql> select concat("a", "b");
+------------------+
| concat('a', 'b') |
+------------------+
| ab |
+------------------+
mysql> select concat("a", "b", "c");
+-----------------------+
| concat('a', 'b', 'c') |
+-----------------------+
| abc |
+-----------------------+
mysql> select concat("a", null, "c");
+------------------------+
| concat('a', NULL, 'c') |
+------------------------+
| NULL |
+------------------------+Keywords
CONCAT