Answer the question
In order to leave comments, you need to log in
How to select from mysql database by condition?
I need to select users from the customers table who registered 15 minutes ago, but not earlier
. That is, if it is now 21:10 and the user registered at 21:00, then with a sql query, he should get out at 21:15, but not earlier .
I had an idea
SELECT * FROM customer WHERE status = 1 AND date_added >= DATE_SUB(NOW() , INTERVAL 15 MINUTE)
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question