mysql对String类型的数字值排序

正常

SELECT
	current_box_num,
	total_box_num 
FROM
	jis_order 
WHERE
	delete_flag = 0 
	AND id IN ( 41362, 41361, 41360, 41359, 41358, 41357, 41356 ) 
ORDER BY
	total_box_num asc

查询结果

但如果total_box_num字段类型是String的话排序就会有问题, 需要在字段前加--

SELECT
	current_box_num,
	total_box_num 
FROM
	jis_order 
WHERE
	delete_flag = 0 
	AND id IN ( 41362, 41361, 41360, 41359, 41358, 41357, 41356 ) 
ORDER BY
	--total_box_num asc

查询结果

或者

SELECT
	current_box_num,
	total_box_num 
FROM
	jis_order 
WHERE
	delete_flag = 0 
	AND id IN ( 41362, 41361, 41360, 41359, 41358, 41357, 41356 ) 
ORDER BY
	total_box_num+0 asc