【mysql 计算星座】根据身份证计算用户所属星座，mysql星座

【mysql 计算星座】根据身份证计算用户所属星座，mysql星座

某一用户身份证是：

522225199507153253

计算此用户的星座为：

星座
巨蟹座

mysql 代码片段：

SELECT 

case

when SUBSTRING(person_card,11,4) between '0120' and '0218' then '水瓶座' 

when SUBSTRING(person_card,11,4) between '0219' and '0320' then '双鱼座'

when SUBSTRING(person_card,11,4) between '0321' and '0419' then '白羊座'  

when SUBSTRING(person_card,11,4) between '0420' and '0520' then '金牛座' 

when SUBSTRING(person_card,11,4) between '0521' and '0621' then '双子座' 

when SUBSTRING(person_card,11,4) between '0622' and '0722' then '巨蟹座' 

when SUBSTRING(person_card,11,4) between '0723' and '0822' then '狮子座' 

when SUBSTRING(person_card,11,4) between '0823' and '0922' then '处女座' 

when SUBSTRING(person_card,11,4) between '0923' and '1023' then '天秤座' 

when SUBSTRING(person_card,11,4) between '1024' and '1122' then '天蝎座' 

when SUBSTRING(person_card,11,4) between '1123' and '1221' then '射手座' 

else '摩羯座'  end as '星座'


 from t_user_info WHERE user_id=191807958893