A numeric argument is converted to its equivalent binary string form.
SELECT CONCAT(CAST(int_col AS CHAR), char_col);
mysql>
mysql> SELECT CONCAT('My', 'S', 'QL');
+-------------------------+
| CONCAT('My', 'S', 'QL') |
+-------------------------+
| MySQL |
+-------------------------+
1 row in set (0.00 sec)