MySQL query help

[Mainer82]

Here's an overview of this table, it holds upcoming items by title and release date, there are x amount of items per month being released.

What I need to do is query how many items are going to be available in the current month.

Here's the query I've tried, but its not working:

SELECT COUNT(*) AS num FROM upcoming WHERE w_date = date_sub(current_month) 

[Lats]

Try this...

SELECT 
    COUNT(*) 
AS 
    num 
FROM 
    upcoming 
WHERE 
    DATE_FORMAT(w_date,'%Y-%m') = DATE_FORMAT(curdate,'%Y-%m')

[Mainer82]

Hi, I tried that query. It returns results, but it returns all items in all months.

I tried this: SELECT COUNT(*) AS num FROM upcoming WHERE DATE_FORMAT(w_date,'%Y-%m') = DATE_FORMAT(current_date,'%Y-%m');

and it worked... thank you!

[Lats]

Ah, should have been curdate().

Glad you got it working.