Hi Gerald,
I tried the following query,
select DATE_FORMAT(expendituredate,"%d-%b-%Y") as expdate,sum(amount) as
amount from expenditure where userid=11 and expendituredate between
'2002-8-01' and '2002-8-31' group by expendituredate order by
expendituredate;
which is not overriding the expenditure column.
Still my query goes for the full table scan.
With regards
kamesh jayachandran
------------------------------------------------------------
Get your FREE web-based e-mail and newsgroup access at:
http://MailAndNews.com
Create a new mailbox, or access your existing IMAP4 or
POP3 mailbox from anywhere with just a web browser.
------------------------------------------------------------
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
