mysql 校验身份证号码

DELIMITER //
CREATE FUNCTION validate_id_card(id_card VARCHAR(18))
RETURNS BOOLEAN
BEGIN
    IF LENGTH(id_card) <> 18 THEN
        RETURN FALSE;
    END IF;
    IF NOT id_card REGEXP '^[0-9Xx]+$' THEN
        RETURN FALSE;
    END IF;
    RETURN TRUE;
END //
DELIMITER ;

DELIMITER //
CREATE FUNCTION validate_area_code(area_code CHAR(6))
RETURNS BOOLEAN
BEGIN
    DECLARE valid_area_codes TEXT;
    SET valid_area_codes = '...'; -- 这里填入有效的地区代码列表
    IF area_code REGEXP CONCAT('^(', valid_area_codes, ')$') THEN
        RETURN TRUE;
    END IF;
    RETURN FALSE;
END //
DELIMITER ;

DELIMITER //
CREATE FUNCTION validate_check_code(id_card VARCHAR(18))
RETURNS BOOLEAN
BEGIN
    DECLARE weights VARCHAR(17);
    DECLARE check_codes CHAR(1);
    SET weights = '7,9,10,5,8,4,2,1,6,3,7,9,10,5,8,4,2';
    SET check_codes = '1,0,X,9,8,7,6,5,4,3,2';

    DECLARE i INT DEFAULT 1;
    DECLARE sum INT DEFAULT 0;
    DECLARE weight INT;
    DECLARE check_code CHAR(1);

    WHILE i <= 17 DO
        SET weight = SUBSTRING_INDEX(SUBSTRING_INDEX(weights, ',', i), ',', -1);
        SET sum = sum + SUBSTRING(id_card, i, 1) * weight;
        SET i = i + 1;
    END WHILE;

    SET check_code = SUBSTRING_INDEX(SUBSTRING_INDEX(check_codes, ',', MOD(sum, 11) + 1), ',', -1);

    RETURN UPPER(SUBSTRING(id_card, 18, 1)) = check_code;
END //
DELIMITER ;