从日期范围内的表中选择一行

Question

is it possible to sellect a row from a table like so

SELECT * FROM users WHERE username=? FROM date 2015-02-17 08:12:54 TO date 2015-02-17 09:12:54

Because I have a login table, and I want to check to make sure they're not bruteforcing.

Is that possible?

Answer 1

The syntax looks like this:

SELECT u.*
FROM users u
WHERE u.username = ? AND
      u.date BETWEEN '2015-02-17 08:12:54' AND '2015-02-17 09:12:54'

If you have a large table, this query can take advantage of an index on users(username, date).