SimonHowald
asked on
MYSQL select records for a specific day from date column
I have a table in mysql with a day column with type DATE.
I need to select all the records for Monday. Is there any way to filter records by putting
the day condition on date column. e.g.
select * from mytable where day = SomeTranslationFunction('S unday');
I need to select all the records for Monday. Is there any way to filter records by putting
the day condition on date column. e.g.
select * from mytable where day = SomeTranslationFunction('S
select * from mytable where day = SomeTranslationFunction('Sunday');
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I do not think there is a problem in adding a function to the query, however you must take into account the output of that function. So you have to be aware of the function you are using.
regards