From: Scott Swaim (scotttmcclinic.com)
Date: Tue Sep 29 2009 - 14:25:36 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Try this

SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3;

Scott Swaim
I.T. Director
Total Care / Joshua Family Medical Care
(817) 297-4455
Website: www.totalcareclinic.com
 
 
NOTICE: The information contained in this e-mail is privileged and
confidential and is intended for the exclusive use of the recipient(s) named
above. If you are not the intended recipient or his or her agent, you are
hereby notified that you have received this document in error and that any
use, disclosure, dissemination, distribution, or copying of this message is
prohibited. If you have received this communication in error, please notify
the sender immediately by e-mail, and delete the original message

-----Original Message-----
From: Kerstin Finke [mailto:kerstinfinkehotmail.com]
Sent: Tuesday, September 29, 2009 8:04 AM
To: mysqllists.mysql.com
Subject: SELECT by day

Hi,
I want to search all rows with datum = 'tuesday' for example, something
like:

SELECT * FROM `table_anw` WHERE datum=DAYOFWEEK(3);
'3' as tuesday.

I found in the manual I can do:
SELECT DAYOFWEEK('1998-02-03');
and will get '3' for Tuesday.

But thats not what I want. I want to select only tuesdays.
Any ideas?

Thanks in advance
Kerstin

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=scotttmcclinic.com

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]