Cacher is the code snippet organizer for pro developers

SELECT *
FROM eventos
WHERE '2014-02-01' BETWEEN date(inicio) AND date(fim);

# Por ano
# '2014' BETWEEN year(inicio) AND year(fim)

# Por mês
# '07' BETWEEN month(inicio) AND month(fim)