CONCAT(str1,str2,...): Concatenate the arguments : CONCAT « String Functions « MySQL Tutorial






  1. MySQL Tutorial
  2. String Functions
  3. CONCAT

A numeric argument is converted to its equivalent binary string form.

SELECT CONCAT(CAST(int_col AS CHAR), char_col);

mysql>
mysql>
mysql>
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL                   |
+-------------------------+
1 row in set (0.00 sec)








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