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