MySQL SQL getting most recent records in a table?

[Nanbargal]

I have an sql statement as below attempting to retrieve the most recent entries in a table. So I have two questions:[*]is it better to order by id or by date?[*]how do I rewrite this sql statement to re-order by date?SELECT id, comment, DATE_FORMAT(entry_date, '%W %H:%i') FROM comments ORDER BY id DESC LIMIT 10