Simplest concatenate string: space
/* mysql> select CONCAT("a"," ","B"); +---------------------+ | CONCAT("a"," ","B") | +---------------------+ | a B | +---------------------+ 1 row in set (0.00 sec) */ select CONCAT("a"," ","B");