group by financial months in mysql

[xuletz]

hello,
I need to query a table and group results by financial months. this means that for example financial January dates from 1st of Jan to 4th of February.
I'd like to group in the query and not select by dates and group with php because this is costly time-wise. so any ideas?

[xuletz]

nevermind. this had such a simple solution I can`t believe I didn`t think of it.