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:
In
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 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 one has
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 without any
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
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 associated