tp5写法:
$gold = Db::table('table')->order('CAST(需要排序的字段 AS UNSIGNED) desc')->limit(10)->select();
原生写法:
select * from table ORDER BY CAST(需要排序的字段 AS UNSIGNED) desc
tp5写法:
$gold = Db::table('table')->order('CAST(需要排序的字段 AS UNSIGNED) desc')->limit(10)->select();
原生写法:
select * from table ORDER BY CAST(需要排序的字段 AS UNSIGNED) desc