UPDATE res SET p01="Fail" WHERE p01<m01 UPDATE res SET p01="Pass" WHERE p01>m01 UPDATE res SET p02="Fail" WHERE p02<m02 UPDATE res SET p02="Pass" WHERE p02>m02 UPDATE res SET p03="Fail" WHERE p03<m03 UPDATE res SET p03="Pass" WHERE p03>m ......up to 30