×××相关的SQL

--根据×××查询年龄 SELECT u.tname, u.sexflag, id_num , CASE WHEN LENGTH(id_num) = 18 THEN YEAR(NOW()) - CAST(SUBSTRING(id_num, 7, 4) AS SIGNED) ELSE '' END AS age, u.org_name FROM TB_GH_USER U;;

 --补充性别字段，1是男，2是女

UPDATE tb_gh_user SET sexflag = CASE WHEN CAST(SUBSTRING(id_num, 17, 1) AS SIGNED) % 2 = 1 THEN '1' ELSE '2' END WHERE LENGTH(id_num) > 2 ;