mysql_身分証明書番号によって性別、年齢、所在省を識別する
1377 ワード
1.性別:
2.年齢:
3.所属省:
IF(mod(SUBSTR(c.reciver_idcard_num,17,1),2),'man','woman') ,
2.年齢:
CASE WHEN c.reciver_idcard_num <>'' THEN (YEAR(CURDATE()) - SUBSTRING(c.reciver_idcard_num,7,4)) ELSE NULL END AS ,
3.所属省:
CASE WHEN d.area_name IS NULL THEN
(CASE LEFT(c.reciver_idcard_num,2) WHEN 11 THEN ' ' WHEN 12 THEN ' ' WHEN 13 THEN ' ' WHEN 14 THEN ' ' WHEN 15
THEN ' ' WHEN 21 THEN ' 'WHEN 22 THEN ' ' WHEN 23 THEN ' ' WHEN 31 THEN ' ' WHEN 32 THEN ' '
WHEN 33 THEN ' ' WHEN 34 THEN ' ' WHEN 35 THEN ' ' WHEN 36 THEN ' 'WHEN 37 THEN ' ' WHEN 41 THEN ' '
WHEN 42 THEN ' ' WHEN 43 THEN ' ' WHEN 44 THEN ' ' WHEN 45 THEN ' ' WHEN 46 THEN ' ' WHEN 50 THEN ' '
WHEN 51 THEN ' 'WHEN 52 THEN ' ' WHEN 53 THEN ' ' WHEN 54 THEN ' ' WHEN 61 THEN ' ' WHEN 62 THEN ' '
WHEN 63 THEN ' ' WHEN 64 THEN ' ' WHEN 65 THEN ' 'end )
ELSE d.area_name END as' '