CONCAT (string1, string2,…) AS column_name
SELECT column1,column2,... FROM table_name WHERE (expr|column_1) IN ('value1','value2',...);
CONCAT (string1, string2,…)
SELECT CONCAT ('C', 'at') "concat" FROM DUMMY;