Query most recent row for each IP? 1

[Yrrk]

Anyone know off the top of their head how i'd run a query to get the most recent entries (datetime) for any given IP?

mysql> describe Stats;
+------------+--------------+------+-----+---------------------+-------+
| Field      | Type         | Null | Key | Default             | Extra |
+------------+--------------+------+-----+---------------------+-------+
| DateTime   | datetime     |      |     | 0000-00-00 00:00:00 |       |
| Used       | varchar(11)  |      |     | 0                   |       |
| Avail      | varchar(11)  |      |     | 0                   |       |
| MPS        | float(5,2)   |      |     | 0.00                |       |
| Sending    | char(1)      |      |     |                     |       |
| Receiving  | char(1)      |      |     |                     |       |
| NumSMAP    | mediumint(9) |      |     | 0                   |       |
| NumSenders | mediumint(9) |      |     | 0                   |       |
| IP         | varchar(15)  |      |     |                     |       |
| AvgSize    | float(9,0)   |      |     | 0                   |       |
| Perc       | mediumint(9) |      |     | 0                   |       |
+------------+--------------+------+-----+---------------------+-------+

 

[TonyGroves]

How about:
[tt]
SELECT ip,MAX(`datetime`)
FROM stats
GROUP BY ip
[/tt]

 

[TonyGroves]

Sorry, it's "most recent entries for any given ip". In that case:
[tt]
SELECT *
FROM stats
WHERE ip='1.2.3.4'
ORDER BY `datetime` DESC
LIMIT 10
[/tt]