UPDATE mmhpbs.tmmhp01 t SET lot_no_1 = '25PR061550' WHERE t.plate_seq_no LIKE  '25PR061550-01';
UPDATE mmhpbs.tmmhp02 t SET SAMPLE_LOT_NO = '25PR061550' WHERE t.plate_seq_no LIKE  '25PR061550-01';

UPDATE MMHPRG.TMMHPRG01 t SET LOT_NO_1 = '25PR061550' WHERE t.plate_seq_no LIKE  '25PR061550-01';


UPDATE tmmhp01 t SET lot_no_1 = '25SR017785' WHERE t.plate_seq_no IN('25SR017785-02','25SR017785-03','25SR017785-04','25SR017785-05');
UPDATE tmmhp02 t SET SAMPLE_LOT_NO = '25SR017785' WHERE t.plate_seq_no IN('25SR017785-02','25SR017785-03','25SR017785-04','25SR017785-05');

UPDATE MMHPRG.TMMHPRG01 t SET LOT_NO_1 = '25SR017785' WHERE t.plate_seq_no IN('25SR017785-02','25SR017785-03','25SR017785-04','25SR017785-05');