case when优化查询之二

要求: 通过客户名称搜索单据信息时, 不同的客户(trader),对应不同的客户类型(traderType)

实现: 通过case when来指定traderType类型

SELECT
  trader, traderType, status
FROM
    yd_order
WHERE
  deleted = '0'
AND STATUS != 'canceled'
AND traderType != 'chain'
AND chainID = '1'
AND
 CASE
    WHEN traderType = 'reseller' THEN
       trader IN ('2')
  ELSE
       trader IN ('2076')
  END
AND date >= '2018-06-25 00:00:00'
AND date <= '2018-06-30 23:59:59'
ORDER BY
    `id` DESC