SELECT contractid FROM contractequipment WHERE (CoID = 80) AND (UnitID like '[a-z]%')SELECT contractid FROM contractequipment WHERE (CoID = 80) AND (UnitID like '[A-Z]%')SELECT contractid FROM contractequipment WHERE (CoID = 80) AND (UnitID like '[a-zA-Z]%')
小写字母 SELECT contractid FROM contractequipment WHERE (CoID = 80) AND (UnitID like '[a-z]%') 大写字母 SELECT contractid FROM contractequipment WHERE (CoID = 80) AND (UnitID like '[A-Z]%') 所有大小写字母 SELECT contractid FROM contractequipment WHERE (CoID = 80) AND (UnitID like '[a-zA-Z]%')
FROM contractequipment
WHERE (CoID = 80) AND (UnitID like '[a-z]%')SELECT contractid
FROM contractequipment
WHERE (CoID = 80) AND (UnitID like '[A-Z]%')SELECT contractid
FROM contractequipment
WHERE (CoID = 80) AND (UnitID like '[a-zA-Z]%')
SELECT contractid
FROM contractequipment
WHERE (CoID = 80) AND (UnitID like '[a-z]%')
大写字母
SELECT contractid
FROM contractequipment
WHERE (CoID = 80) AND (UnitID like '[A-Z]%')
所有大小写字母
SELECT contractid
FROM contractequipment
WHERE (CoID = 80) AND (UnitID like '[a-zA-Z]%')