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

Re: SELECT by day

Have you tried this? SELECT * FROM `table_anw` WHERE DAYOFWEEK(datum) = 3; Kerstin Finke kerstinfi...@hotmail.com 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

RE: SELECT by day

this 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

RE: SELECT by day

@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 DAYOFWEEK('1998-02-03'); and will get '3' for Tuesday. But thats not what I