mysql字符串提取数组排序

select cast('123456@xx.com' as unsigned);

SELECT id  ,parent_id  ,resource_name  ,resource_path  ,resource_icon  , cast(detail as unsigned)  detail  FROM t_adn_resource WHERE parent_id='258fdc82e54047c1b2a89c69b54680b4' ORDER BY detail