Re: Searching for Dates

2007-03-20 Thread Bob Cooper
To you all, Thanks for your input. The "TO_DAYS(date_col)%4 = TO_DAYS('2006-4-17')% 4" where statement worked perfectly. And, thanks for the reference to the manual. It can be a bit daunting for a newbie. Bob Cooper > Dan: > > Thanks! > > Jim > >

Searching for Dates

2007-03-17 Thread Bob Cooper
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