以下の構文で携帯メールかPCメールかの判定ができる
ドメインはどっかで拾ってきた
下の範囲指定の[数字1]に下限、[数字2]に上限を設定で注文番号の範囲指定ができます。
--------------------------------------------------------------------------------------
CASE WHEN o.order_email like '%docomo.ne.jp%'
OR o.order_email like '%mopera.net%'
OR o.order_email like '%softbank.ne.jp%'
OR o.order_email like '%vodafone.ne.jp%'
OR o.order_email like '%disney.ne.jp%'
OR o.order_email like '%i.softbank.jp%'
OR o.order_email like '%ezweb.ne.jp%'
OR o.order_email like '%uqmobile.jp%'
OR o.order_email like '%ido.ne.jp%'
OR o.order_email like '%emnet.ne.jp%'
OR o.order_email like '%emobile.ne.jp%'
OR o.order_email like '%emobile-s.ne.jp%'
OR o.order_email like '%ymobile1.ne.jp%'
OR o.order_email like '%ymobile.ne.jp%'
OR o.order_email like '%yahoo.ne.jp%'
OR o.order_email like '%pdx.ne.jp%'
OR o.order_email like '%willcom.com%'
OR o.order_email like '%wcm.ne.jp%'
OR o.order_email like '%y-mobile.ne.jp%' THEN '携帯'
ELSE 'PC'
END as "PCor携帯"
FROM
dtb_order AS o
-----範囲指定箇所はここになります-----
WHERE
o.order_id >= [数字1]
AND
o.order_id <= [数字2]
--------------------------------------
ドメインはどっかで拾ってきた
下の範囲指定の[数字1]に下限、[数字2]に上限を設定で注文番号の範囲指定ができます。
--------------------------------------------------------------------------------------
CASE WHEN o.order_email like '%docomo.ne.jp%'
OR o.order_email like '%mopera.net%'
OR o.order_email like '%softbank.ne.jp%'
OR o.order_email like '%vodafone.ne.jp%'
OR o.order_email like '%disney.ne.jp%'
OR o.order_email like '%i.softbank.jp%'
OR o.order_email like '%ezweb.ne.jp%'
OR o.order_email like '%uqmobile.jp%'
OR o.order_email like '%ido.ne.jp%'
OR o.order_email like '%emnet.ne.jp%'
OR o.order_email like '%emobile.ne.jp%'
OR o.order_email like '%emobile-s.ne.jp%'
OR o.order_email like '%ymobile1.ne.jp%'
OR o.order_email like '%ymobile.ne.jp%'
OR o.order_email like '%yahoo.ne.jp%'
OR o.order_email like '%pdx.ne.jp%'
OR o.order_email like '%willcom.com%'
OR o.order_email like '%wcm.ne.jp%'
OR o.order_email like '%y-mobile.ne.jp%' THEN '携帯'
ELSE 'PC'
END as "PCor携帯"
FROM
dtb_order AS o
-----範囲指定箇所はここになります-----
WHERE
o.order_id >= [数字1]
AND
o.order_id <= [数字2]
--------------------------------------