concatenate string

Sometimes you may want to concatenate strings or multiple columns in MySQL. Here is how to concatenate strings in MySQL.