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 `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=arch...@jab.org
