笨办法,枚举,好在选项不多,解决了第一个问题:
DELETE FROM a WHERE NOT zymc IN ("化学","化学(师范)","化学类") AND NOT ("化学"$bz OR "应用化学"$bz) OR zymc in ("化学工程","化学测量")
第二个问题,牵涉到在备注中如何精确查找的问题,如何解决呢?
DELETE FROM a WHERE NOT zymc IN ("化学","化学(师范)","化学类") AND NOT ("化学"$bz OR "应用化学"$bz) OR zymc in ("化学工程","化学测量")
第二个问题,牵涉到在备注中如何精确查找的问题,如何解决呢?