per la settimana seguentecodice:select * from tabella where week(curdate(),1) between week(prima_data,1) and week(seconda_data,1)
codice:select * from tabella where week(curdate() + interval 1 week,1) between week(prima_data,1) and week(seconda_data,1)