How to CONCAT in MySQL

One of the most common tasks with strings is concatenation! This blog post showcases several techniques to perform it with MySQL.