I have a database which has product codes and release dates.
I want to be able to select all items that have a release date that falls within the current week.
I want a seperate select which selects all items that have a release date that falls within the following week.
Is there a way to set up the mysql select for the dates to fall in a certain week? Or will I have to use a date range instead?
Example of use: SELECT * FROM products_table where GET_WEEK(product_release_date) = CURRENT_WEEK.