MYSQL将多条语句按条件组合成一条

SELECT match_uni_key,origin_type,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘1X2’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘1X2_half_origin_disc’,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘AH’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘AH_half_origin_disc’,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘OU’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘OU_half_origin_disc’,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘CORNER’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘CORNER_half_origin_disc’,

MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘1X2’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘1X2_origin_disc’,
MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘AH’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘AH_origin_disc’,
MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘OU’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘OU_origin_disc’,
MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘CORNER’ THEN (CASE stage WHEN ‘ORIGIN’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘CORNER_origin_disc’,

MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘1X2’ THEN (CASE stage WHEN ‘START’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘1X2_half_start_disc’,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘AH’ THEN (CASE stage WHEN ‘START’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘AH_half_start_disc’,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘OU’ THEN (CASE stage WHEN ‘START’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘OU_half_start_disc’,
MAX(CASE half_type WHEN 1 THEN (CASE type WHEN ‘CORNER’ THEN (CASE stage WHEN ‘START’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘CORNER_half_start_disc’,

MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘1X2’ THEN (CASE stage WHEN ‘START’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘1X2_start_disc’,
MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘AH’ THEN (CASE stage WHEN ‘START’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘AH_start_disc’,
MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘OU’ THEN (CASE stage WHEN ‘START’ THEN odds_a ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘OU_start_disc’,
MAX(CASE half_type WHEN 2 THEN (CASE type WHEN ‘CORNER’ THEN (CASE stage WHEN ‘START’ THEN odds_b ELSE ‘’ END) ELSE ‘’ END) ELSE ‘’ END) ‘CORNER_start_disc’
FROM t_match_odds_cache_2018 WHERE stage IN (‘ORIGIN’, ‘START’) AND type IN(‘1X2’, ‘AH’,‘OU’,‘CORNER’)
GROUP BY match_uni_key LIMIT 30

主要用到的时MYSQL的 CASE WHEN方法进行判断，然后再用MAX函数，将数据组合到一条数据中