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/[email protected]
