mysql 工作日计算

SELECT COUNT(*) AS workdays
FROM (
    SELECT DATE_ADD('2023-01-01', INTERVAL n DAY) AS date
    FROM (
        SELECT @row := @row + 1 AS n
        FROM (SELECT 0 UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5 UNION ALL SELECT 6 UNION ALL SELECT 7 UNION ALL SELECT 8 UNION ALL SELECT 9) AS a
        CROSS JOIN (SELECT @row := 0) r
        LIMIT 31
    ) AS numbers
) AS dates
WHERE DAYOFWEEK(date) BETWEEN 2 AND 6 -- 2=Monday, 6=Friday
AND date NOT IN ('2023-01-01', '2023-01-02'); -- 排除节假日