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

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