The following statement helped Roger Backlund me with a few days ago, It works great but now I need to make it more advance and I don#t get any where to find the right solution..
SELECT COUNT(created) from SUBSCRIBER where date_format( date_sub(now(), interval 1 day), '%Y%m%d%H%i%s') <= created; the db-table (table name is SUBSCRIBER) have the following columns as follows: ID email created updated 001 [EMAIL PROTECTED] 20050215131034 20050215133401 063 [EMAIL PROTECTED] 20050215141034 20050215141201 076 [EMAIL PROTECTED] 20050215134500 20050215134556 The other table is called SUBSCRIPTIONS and look like following ID sys_id 001 1 063 2 076 3 The data type of the columns are: ID =VARCHAR(14) email =VARCHAR(255) created =VARCHAR(14) updated =VARCHAR(14) sys_id =VARCHAR(14) What I want to do is to be able to check the last hours new rows for a specific sys_id , (not list) only to get out how many rows that have been added... Thanks! -- ___________________________________________________________ Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]