1、varchar转int
select * from SYS_MENU where PARENT_ID = '6' order by cast (MENU_ORDER as UNSIGNED INTEGER) ;
select * from SYS_MENU where PARENT_ID = '6' order by cast (MENU_ORDER as SIGNED INTEGER)
1、varchar转int
select * from SYS_MENU where PARENT_ID = '6' order by cast (MENU_ORDER as UNSIGNED INTEGER) ;
select * from SYS_MENU where PARENT_ID = '6' order by cast (MENU_ORDER as SIGNED INTEGER)