Try using SELECT [fields] FROM [table] ORDER BY [date_field] DESC LIMIT 5
Regards
Jorge
MySQL Development Team
__ ___ ____ __ __
/ |/ /_ __/ __/ __ \/ / Jorge del Conde <jorge@stripped>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/
/_/ /_/\_, /___/\___\_\____/ Mexico City, Mexico
<___/
----- Original Message -----
From: "FL" <f.lecorre@stripped>
To: <win32@stripped>
Sent: Monday, January 08, 2001 2:33 PM
Subject: 5 last records ?
> Hi,
>
> How to build an efficient query to display the 5 last records (order by
> date) ?
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread4728@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
