SELECT * FROM `seats` WHERE `ID` LIKE 'p-r2-%' AND (RIGHT(`ID`, 1) % 2) = 0 AND `Status` = 2;

UPDATE `seats` SET `Status` = 0 WHERE `ID` LIKE 'p-r2-%' AND (RIGHT(`ID`, 1) % 2) = 0 AND `Status` = 2;