In MySQL, how to return the week of the month?

Question

This question already has answers here: question from:https://stackoverflow.com/questions/65598814/how-could-i-use-mysql-row-number-over-with-mysql-server-not-mariadb

Answer 1

FLOOR((DayOfMonth(dateCol)-1)/7)+1

I'd like to make it clear that this is probably not a good way to divide your data - (see the comments), but that this will get you as close as you can get.