CONCAT() returns NULL if any argument is NULL. : CONCAT « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. CONCAT
mysql>
mysql>
mysql>
mysql> SELECT CONCAT('My', NULL, 'QL');
+--------------------------+
| CONCAT('My', NULL, 'QL') |
+--------------------------+
| NULL                     |
+--------------------------+
1 row in set (0.00 sec)

mysql>








23.8.CONCAT
23.8.1.CONCAT(str1,str2,...): Concatenate the arguments
23.8.2.CONCAT() returns NULL if any argument is NULL.
23.8.3.SELECT CONCAT(14.3);
23.8.4.Using CONCAT with table column
23.8.5.Use Concat data from two different columns