Re: help with sql query : DATETIME function

[Paul DuBois]

At 18:30 -0800 2/26/03, Admin-Stress wrote:
I have a table with this structure :

  username VARCHAR(32)
  address  VARCHAR(128)
  datereg  DATETIME      // date of registration
  class    INT
How is the sql query for username who are their datereg was 30 days 
ago and class = 1?
WHERE class = 1 AND datereg = DATE_SUB(CURDATE(),INTERVAL 30 DAY)

thanks


---------------------------------------------------------------------
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/           (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php