]
Sent: Tuesday, September 29, 2009 9:04 AM
To: mysql@lists.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 DA
communication in error, please notify
the sender immediately by e-mail, and delete the original message
-Original Message-
From: Kerstin Finke [mailto:kerstinfi...@hotmail.com]
Sent: Tuesday, September 29, 2009 8:04 AM
To: mysql@lists.mysql.com
Subject: SELECT by day
Hi,
I want to search all
Have you tried this?
SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3;
"Kerstin Finke" escreveu na mensagem
news:20090929130406.9802.qm...@lists.mysql.com...
> Hi,
> I want to search all rows with datum = 'tuesday' for example, something
> like:
>
> SELECT * FROM `table_anw` WHERE datum=DA
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
