mysql concat in select inside select code example

Example: concat in mysql

CONCAT (string1, string2,…)