concat in mysql code example

Example 1: mysql is in list

SELECT 
    column1,column2,...
FROM
    table_name
WHERE 
	(expr|column_1) IN ('value1','value2',...);

Example 2: concat in mysql

CONCAT (string1, string2,…)

Example 3: concat function in hana sql

SELECT CONCAT ('C', 'at') "concat" FROM DUMMY;