ami tribva da e neshto takova ....

select tva_koeto_mi_triabva FROM my_table WHERE time_pole between DATE_SUB(now(), INTERVAL 2 DAY) and DATE_SUB(now(), INTERVAL 1 DAY);