MySQL YEARWEEK()

SELECT YEARWEEK(curdate(), 0) FROM DUAL UNION ALL
SELECT YEARWEEK(curdate(), 1) FROM DUAL;

201753
201801

Mode    First day of week 
0       Sunday
1       Monday