MySQL's `yearweek` function has eight different modes for determining the yearweek. This will get the same yearweek for each mode, with `4` being the default mode.
Dean Morin
July 29, 2013 3:46am
MIT