WHERE (ENROLL_SCHOOL = '300000001530415' AND ENROLL_DEPART IN ('56','59','57','58','60','61','62','63') AND ENROLL_CURRICULUM IN ('54','32','34','33','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53') AND ENRLL_GRADE IN ('175','111','112','101','102','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','103','104','235','236','90','93','91','92','94','95','96','97','98','99','100','105','88','89','106','107','108','109','237','238','239','240','241','242','243','244') AND ENTRLL_TREM = '98')
ENROLL_DEPART IN ('56','59','57','58','60','61','62','63')
上述一段表示表里ENROLL_DEPART 这列的值可以为'56','59','57','58','60','61','62','63'中的任意一个。
其他类推。
你粘出来的这一段是sql中的条件子句，where后面跟的就是查询的条件，ENROLL_SCHOOL = '300000001530415'就表示ENROLL_SCHOOL这个字段的值是300000001530415，ENROLL_DEPART IN ('56','59','57','58','60','61','62','63')就表示字段ENROLL_DEPART的值是in后面的数字中的任意一个，ENROLL_CURRICULUM IN（...）表示字段ENROLL_CURRICULUM的值是in后面数字中的任意一个，ENTRLL_TREM = '98'表示字段ENTRLL_TREM的值是98，你所有的条件之间都有用and连接，就表示用and连接的每一个条件都要满足，所以你这个条件语句的意思是：字段ENROLL_SCHOOL的值为300000001530415、并且字段ENROLL_DEPART的值在是后面括号中那一串数字之一、并且字段ENROLL_CURRICULUM的值是后面括号中那些数字之一、并且字段ENTRLL_TREM的值为98