mysql>
mysql>
mysql> SELECT CONCAT('cats', ' ', 'and', ' ', 'dogs');
+-----------------------------------------+
| CONCAT('cats', ' ', 'and', ' ', 'dogs') |
+-----------------------------------------+
| cats and dogs |
+-----------------------------------------+
1 row in set (0.00 sec)