CREATE TABLE IF NOT EXISTS `Predpr` (
 `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
 `mon` time,
 `mon2` time,
 `tue` time,
 `tue2` time,
 `wed` time,
 `wed2` time,
 `thu` time,
 `thu2` time,
 `Fri` time,
 `Fri2` time,
 `Sat` time,
 `Sat2` time,
 `Sun` time,
 `Sun2` time,
  CONSTRAINT apt_id PRIMARY KEY (`id`),
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

select DAYOFWEEK(NOW())

select (NOW())

select case DAYOFWEEK(CURDATE()-1)
when 1 then if(CURTIME() between `mon` and `mon2`, 1, 0)
when 2 then if(CURTIME() between `tue` and `tue2`, 1, 0)
when 3 then if(CURTIME() between `wed` and `wed2`, 1, 0)
when 4 then if(CURTIME() between `thu` and `thu2`, 1, 0)
when 5 then if(CURTIME() between `Fri` and `Fri2`, 1, 0)
when 6 then if(CURTIME() between `Sat` and `Sat2`, 1, 0)
when 7 then if(CURTIME() between `Sun` and `Sun2`, 1, 0)
end as `tm`
from Predpr;