|
select if('2006-11-01'>date_sub(curdate(),interval 7 day),'within the last week','more than a week old');
something like that will work.
substitute your field name in the place where I put the date
__________________
SnapReplay.com a different way to share photos - iPhone & Android
|