select SimNum,CarNum from GisCar WHERE NOT(SIMNUM LIKE '86%') OR NOT (CarNum NOT LIKE '闽%') select SimNum,CarNum from GisCar WHERE SimNum like '[^81]%' --8或者1开头,集合[]