MySQL查询不适用于新的phpmyadmin

Question

I may have found a bug?

I'm trying to select values where the time is after or 10 minutes before the current time.

Query with the new phpmyadmin

EXACT same query with EXACT same database but with old phpmyadmin

• The databases are IDENTICAL, I exported from the new phpmyadmin to the old one.
• There is an hour between the databases, though (new one being with my hosting). But even then, the results showed are greater than an hour.

Here's the query if anyone wants to test

SELECT times.lastloggedin 
FROM times 
WHERE times.lastloggedin >= NOW() - INTERVAL 10 MINUTE 
ORDER BY lastloggedin

Or I can provide the table for you to test on your own database

I also forgot to mention that these queries are being run within a few seconds of each other too, so they're accurate

Answer 1

Found the problem was with my hosting time being back many hours and I had >= so anything greater than the time was showing!