-- INFO: samo chetni nimera ot balkon 1
SELECT * FROM `seats` WHERE `ID` like 'b1-r%' AND RIGHT(`ID`, 1) % 2 = 0;

-- INFO: dostypni za prodajba
UPDATE `seats` SET `Status` = 0 WHERE `ID` like 'b1-r%' AND RIGHT(`ID`, 1) % 2 = 0;

-- INFO: samo chetni nimera ot balkon 2
SELECT * FROM `seats` WHERE `ID` like 'b2-r%' AND RIGHT(`ID`, 1) % 2 = 0;

-- INFO: dostypni za prodajba ot balkon 2
UPDATE `seats` SET `Status` = 0 WHERE `ID` like 'b2-r%' AND RIGHT(`ID`, 1) % 2 = 0;

-- INFO: dostypni za prodajba parter
UPDATE `seats` SET `Status` = 0 WHERE  `ID` LIKE 'p-r%' AND RIGHT(`ID`, 1) % 2 = 0;

-- INFO: izkliuchvane za prodajba parter red 1
UPDATE `seats` SET `Status` = 2 WHERE  `ID` LIKE 'p-r1-m%' AND RIGHT(`ID`, 1) % 2 = 0;
