프로그램/- Sql

[Mysql] 문자열 합치기 CONCAT

짬타이거♬ 2014. 11. 13. 16:44 
SELECT CONCAT(CAST(int_col AS CHAR), char_col);



mysql> SELECT CONCAT('My', 'S', 'QL');
        -> 'MySQL'
mysql> SELECT CONCAT('My', NULL, 'QL');
        -> NULL
mysql> SELECT CONCAT(14.3);
        -> '14.3'


mysql> SELECT CONCAT_WS(',','First name','Second name','Last Name');
        -> 'First name,Second name,Last Name'
mysql> SELECT CONCAT_WS(',','First name',NULL,'Last Name');
        -> 'First name,Last Name'


출처 : http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_concat