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
本文来自博客园,作者:.net&new,转载请注明原文链接:https://www.cnblogs.com/wugh8726254/p/16853164.html