SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > 90
SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > '90'
a.probability = '100%'
结果不同,两边都是字符串类型的数字的时候要把其中一边转为数字
SELECT a.* FROM test a WHERE left(a.probability,length(a.probability)-1) > CAST('90' AS SIGNED)