Keith C. Ivey wrote:
On 1 Dec 2003 at 16:32, Kevin Carlson wrote:
select * from DateInfo where DATE_FORMAT(updateDate, '%m/%Y') =
'03/2003'
I have an index on the updateDate column but it does not seem to be
used since I am altering the value with the DATE_FORMAT function in
the where clause.
On 1 Dec 2003 at 16:32, Kevin Carlson wrote:
> select * from DateInfo where DATE_FORMAT(updateDate, '%m/%Y') =
> '03/2003'
>
> I have an index on the updateDate column but it does not seem to be
> used since I am altering the value with the DATE_FORMAT function in
> the where clause.
How about s
Keith C. Ivey wrote:
On 1 Dec 2003 at 13:41, Kevin Carlson wrote:
Does MySQL support formatted indexes such as in the statement below?
alter table DateInfo add index monthYear (DATE_FORMAT(updateDate,
'%m/%Y'))
What sort of queries would that help you with?...
This helps with queries
On 1 Dec 2003 at 13:41, Kevin Carlson wrote:
> Does MySQL support formatted indexes such as in the statement below?
>
>alter table DateInfo add index monthYear (DATE_FORMAT(updateDate,
> '%m/%Y'))
What sort of queries would that help you with? The only thing I can
see is if you were trying
Does MySQL support formatted indexes such as in the statement below?
alter table DateInfo add index monthYear (DATE_FORMAT(updateDate,
'%m/%Y'))
If not, does anyone know of any plans to support this in the future?
Thanks,
Kevin
--
MySQL General Mailing List
For list archives: http://lists.m