mysql 中字符串和数字的转换

mysql 中字符串和数字的转换,把字符处加个0就可以了

mysql 中字符串和数字的转换
把字符处加个0就可以了
SELECT b.* , (b.sys_id + 0) as onum FROM `t_word_unit` b WHERE b.sys_id IN (SELECT DISTINCT (a.unit_id) AS bunitid FROM `t_word_group` a WHERE book_id = '1' ) order by onum asc