Mega Code Archive

 

Categories / MySQL / String

 

Simplest concatenate string

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