mysql通过sql语句将string变为int

mysql里面用sql语句让字符串的‘123’转换为数字的123

1.SELECT CAST('123' AS SIGNED integer);
2.SELECT CONVERT('123',SIGNED);
3.SELECT '123'+0;