mysql varchar 转int排序

  • Post author:
  • Post category:mysql


ORDER BY (VALUE +1) DESC
ORDER BY CAST(VALUE AS SIGNED) DESC
ORDER BY convert(VALUE , SIGNED) DESC;



版权声明:本文为qq_37538698原创文章,遵循 CC 4.0 BY-SA 版权协议,转载请附上原文出处链接和本声明。