mysql处理字符串的几点总结:
1,截取动态字符串
SELECT LEFT('12,3,5,6,7', LENGTH('12,3,5,6,7') - LOCATE(',', REVERSE('12,3,5,6,7')))
2,字符串转化成整数
方法一:SELECT CAST(
'19'
AS SIGNED);
方法二:SELECT CONVERT(
'20'
,SIGNED);
方法三:SELECT
'19'
+
0
;