How do I get data from mysql based on week number?
Posted: Mon Oct 21, 2002 6:48 am
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?
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?