"Jesper Andersson" <[EMAIL PROTECTED]> wrote on 15/02/2005 13:15:43:
> Hello,
>
> I relly new with databases and writing sql-questions.
>
> But in my db want I to check what have new rows have come the last hour.
>
> the db have I as follow:
>
> ID email created updated
> 001 [EMAIL PROTECTED] 20050215131034 20050215133401
> 063 [EMAIL PROTECTED] 20050215141034 20050215141201
> 76 [EMAIL PROTECTED] 20050215134500 20050215134556
>
> Now I would like to make a sql-question that show which new users
> have come the last hour, without that I need to edit the question
> each time I want to ask.
select <colums> from <table> where date_sub(now(), interval 1 hour) <=
created ;
Alec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
