数据库 - where后面字符串转数字
FillerOrderNumber列的类型为TEXT,里面的值为
使用CAST转为数值类型
SELECT * FROM check_table WHERE 3 <= CAST(`FillerOrderNumber` AS SIGNED) AND CAST(`FillerOrderNumber` AS SIGNED) <= 1001 LIMIT(5)
FillerOrderNumber列的类型为TEXT,里面的值为
使用CAST转为数值类型
SELECT * FROM check_table WHERE 3 <= CAST(`FillerOrderNumber` AS SIGNED) AND CAST(`FillerOrderNumber` AS SIGNED) <= 1001 LIMIT(5)