select variable time interval (no replies)
(MySQL.com) within a case statement I have the following:
('all sessions 2'.producer_on >= DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY))
which gives me the activity I want for the past 7 days.
What I want to do is to replace the 7 with a variable from a table
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:14:58
