Hi, I am working with MySQL ver 5.1 on a Ubuntu Linux x86_64. I am new to both SQL and MySQL. I have been able to query out most of the data I need from my tables without any issues but his one has stumped me.
I am trying to query data associated with specific dates. The dates are not sequential but somewhat sporadic. I would like to query out data/dates that are every 4 days from a starting date. 2006-4-17, 2006-4-21, etc. I have tried ADDDATE('2006-4-14',interval 4 day)<=Date_col but it give me only the next date 2006-4-21. any help would be greatly appreciated, Coop. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]