上面一张表,我要根据当前时间过滤出对应的值:
SELECT
`CODE`,
levelValue
FROM
leveldate
WHERE
DATE_FORMAT( NOW(), '%m%e' ) >= firstMonth
AND DATE_FORMAT( NOW(), '%m%e' ) <= endMonth
当前日期对应的角色级别:
上面一张表,我要根据当前时间过滤出对应的值:
SELECT
`CODE`,
levelValue
FROM
leveldate
WHERE
DATE_FORMAT( NOW(), '%m%e' ) >= firstMonth
AND DATE_FORMAT( NOW(), '%m%e' ) <= endMonth
当前日期对应的角色级别: