MySQL Lists: mysql: Re: how to

List:	General Discussion	« Previous Message Next Message »
From:	Tonu Samuel	Date:	May 29 2001 9:32am
Subject:	Re: how to
View as plain text

On 29 May 2001 09:28:04 +0200, Signe Hasseriis wrote:
> Please tell me how to select the 10 (or 5) newest records or posts from a MySql
> table.
> 


SELECT * FROM table ORDER BY posttime DESC LIMIT 5


-- 
MySQL Security Administrator
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /   Tonu Samuel <tonu@stripped>
 / /|_/ / // /\ \/ /_/ / /__  MySQL AB, http://www.mysql.com/
/_/  /_/\_, /___/\___\_\___/  Tallinn, Estonia
       <___/

Thread
• how to	Signe Hasseriis	29 May
• Re: how to	Harald Fuchs	29 May
• Re: how to	Mohamad Ilhami	29 May
• Re: how to	Tonu Samuel	29 May
• Re: how to	Mark Worsdall	29 May