坑之mysql 字符串与数字操作时间:2023-03-09 15:24:22 select "123"+1 = 124; select "1a23"+1 = 2; select "aa23"+1 = 1; select "aa" = 0 -------------true;大坑,切记 select "1aa"=0--------------false; 总结,1.string和int比较时,是string迁就int,字符串转化成数字进行比较的; 2.字符串转化规则:截取最前面的数字部分;