SELECT
CASE WHEN t1.xfxs='0100' THEN 'xxx' WHEN t1.xfxs = '0200' THEN 'yyy' END as 'zzz',
CONCAT(t1.`name1`,t1.`name2`,t1.`name3`) as 'AAA',
FROM
letter t1
WHERE
xxxxx
SELECT
CASE WHEN t1.xfxs='0100' THEN 'xxx' WHEN t1.xfxs = '0200' THEN 'yyy' END as 'zzz',
CONCAT(t1.`name1`,t1.`name2`,t1.`name3`) as 'AAA',
FROM
letter t1
WHERE
xxxxx