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
>
> > In the last episode (Mar 18), Jim Ginn said
Dan:
Thanks!
Jim
> In the last episode (Mar 18), Jim Ginn said:
>> > In the last episode (Mar 16), Bob Cooper said:
>> >> 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 wi
In the last episode (Mar 18), Jim Ginn said:
> > In the last episode (Mar 16), Bob Cooper said:
> >> 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 on
Dan:
I've used the TO_DAYS on a SELECT statement ie:
SELECT * FROM properties WHERE
(TO_DAYS(NOW()) - TO_DAYS(CreationDate) = 1) ORDER BY id DESC
however it didn't seem to take advantage or use the index on that field
(ie. CreationDate) ...
Jim
> In the last episode (Mar 16), Bob Cooper said:
In the last episode (Mar 16), Bob Cooper said:
> 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 associate
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
