BrainPill Posted March 2, 2018 Share Posted March 2, 2018 Quote SELECT * FROM `my_tab` rec_nr form_nr nonce_number login_time ip_fict created_on 1 3101255 5a71b1d6dcb71 1517400534 12.34.5.0 2018-01-31 13:08:54 2 9069570 5a71b319adc72 1517400857 12.34.5.0 2018-01-31 13:14:17 3 7399905 5a71fd2075ce8 1517419808 12.34.5.0 2018-01-31 18:30:08 4 8635151 5a71fd2904493 1517419817 12.34.5.0 2018-01-31 18:30:17 5 9956260 5a72a96e8f080 1517463918 12.34.5.0 2018-02-01 06:05:18 6 1679771 5a72a975bc0c3 1517463925 12.34.5.0 2018-03-02 06:40:25 7 9342245 5a72a97c52a5e 1517463932 12.34.5.0 2018-03-02 06:45:32 8 2744250 5a72fe0149614 1517485569 12.34.5.0 2018-03-02 12:46:09 9 1954005 5a72fe92a4f09 1517485714 12.34.5.0 2018-03-02 12:48:34 10 7756038 5a7300125b748 1517486098 12.34.5.0 2018-03-02 12:54:58 Hi. This is the table output I have while using SELECT. Now I want to DELETE all records , except those from the last 3 hours. I tried mysql combined with now() and I tried this: SELECT * FROM `my_tab` WHERE SEC_TO_TIME(-10800) > `created_on` If someone can give the right setup how to do this in PHP/MYSQL then I would be very happy. Link to comment Share on other sites More sharing options...
Ingolme Posted March 2, 2018 Share Posted March 2, 2018 You can use the condition `created_on` < DATE_SUB(NOW(), INTERVAL 3 HOUR). It uses the DATE_SUB() function. 1 Link to comment Share on other sites More sharing options...
BrainPill Posted March 2, 2018 Author Share Posted March 2, 2018 Thanks for helping me out Ingolme Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now