mysql 查询30分钟内的验证码

mysql 查询30分钟内的验证码

select t.`value` as `value` from t_message_info t

where t.user_name = 13072281151 AND t.`key` = 1 AND t.is_use = 0 AND t.create_time IS NOT NULL AND t.create_time>DATE_ADD(NOW(), INTERVAL -33 MINUTE) ORDER BY t.create_time DESC LIMIT 0,1

原文链接：https://blog.csdn.net/andZuo/article/details/82459009