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
原文：https://www.cnblogs.com/Jack-zhao/p/13181252.html