SQLzoo.net

Put two fields together (concatenate)

MySQL

You can put two or more strings together using the concatentate operator. The SQL standard says you should use || but there are many differences between the main vendors.



Specific to MySQL
Use CONCAT

Related links:

  • SELECT