sql case when

 

1、else后面直接跟列名就是原值。

2、

  SELECT

        id, user_mobile, start_province_id, start_city_id, start_county_id, start_station,
        end_province_id, end_city_id, end_county_id, end_station, send_date, start_time,
        end_time,
        CASE
        WHEN TIMESTAMPDIFF(
        MINUTE,
        SYSDATE(),
        CONCAT(
        send_date,
        ' ',
        SUBSTR(end_time FROM 1 FOR 2),
        ':',
        SUBSTR(end_time FROM 3 FOR 4),
        ':00'
        )
        ) < 0 THEN
        '3'
        ELSE
        status
        END AS status,
        line_id, create_time, update_time, del_flag, spare1, spare2, spare3,
        spare4, spare5, spare6, spare7, spare8, spare9, spare10

        FROM

        u_custom_line