I want to extract data from a mysql table based on week numbers.
something like this: select * from table where (date = week 42)
I know how to do it in php, but I there is no need to load the whole database into memory, when I know it can be done with a simple sql statement. I just dont know how, so can some kind person please show me how?
How do I get data from mysql based on week number?
Moderator: General Moderators
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
http://www.mysql.com/doc/en/Date_and_ti ... tions.html
Maybe something like:
Mac
Maybe something like:
Code: Select all
SELECT field1, field2, field3, date FROM table WHERE WEEK(date) = 42