Q:

SELECT * FROM table WHERE MONTH = next month at today

I am trying to make a small and lightweight PHP based work table system. I know on net I can find many, but these are so overdozed to me.
I have table with:
ID
date
user_name
workplace1_am
workplace1_pm
workplace2_am
workplace2_pm

For current month and current date I solved problem.
Now I need to get data from the table only for next month:
SELECT * FROM table WHERE ...

A:

With date field
SELECT * FROM table WHERE month = NOW() + INTERVAL 1 MONTH

With timestamp field
SELECT * FROM table WHERE MONTH(date) = MONTH(NOW() + INTERVAL 1 MONTH) AND YEAR(date) = YEAR(NOW() + INTERVAL 1 MONTH)

A:

A good example is to make sure your month column is a DATE() so cast it to a date,
then compare to the CURDATE() which pulls out a date. NOW() pulls out the date and the time which won't work when comparing to a date.
SELECT whatever_you_need
FROM table
WHERE date = CURDATE() + INTERVAL 1 MONTH

NOTE: I don't recommend you just pull everything out with a SELECT *, you should always pull out the specific rows you need
EDIT:
to find for a year and month you could do this
SELECT whatever_you_need
FROM table
WHERE EXTRACT(year_month FROM date) = EXTRACT(year_month FROM CURDATE() + INTERVAL 1 MONTH)

WORKING FIDDLE DEMO
year_month returns data in yyyymm format so it is a unique comparison by month and year in one function call

