Как сделать выборку по двум периодам?

Question

[karasique]

По месяцу знаю как:

select * from table WHERE MONTH(date) = MONTH(NOW()) AND YEAR(date) = YEAR(NOW())

А как выбрать записи с 1-15 число или с 16 и до конца месяца?

Answer 1

[Станислав Шендаков]

#Первая половина месяца
SELECT * 
FROM `table ` 
WHERE 
MONTH(date) = MONTH(NOW()) 
AND 
YEAR(date) = YEAR(NOW()) 
AND 
DAY(date) <= 15
ORDER BY date;

#Вторая половина месяца
SELECT * 
FROM `table ` 
WHERE 
MONTH(date) = MONTH(NOW()) 
AND YEAR(date) = YEAR(NOW()) 
AND 
DAY(date) > 15
ORDER BY date;