数据库中字符串类型比较跟数字类型比较不同,具体可以自己区尝试! SELECT CAST("80" AS SIGNED(10)) <= CAST("100" AS SIGNED(10)) select "80" < "100"