When there is only one string to concatenate, CONCAT_WS does not append a separator: SELECT CONCAT_WS(',', 'one'); +-----------------------+ | CONCAT_WS(',', 'ONE') | |-----------------------| | one | +---------