查询语句数字排列的问题 - V2EX

Home Sign Up Sign In

› MySQL 5.5 Community Server

› MySQL 5.6 Community Server

› Percona Configuration Wizard

› XtraBackup 搭建主从复制

Great Sites on MySQL

› MySQL Performance Blog

› Severalnines

推荐管理工具

推荐书目

› MySQL Cookbook

MySQL 相关项目

参考文档

› http://mysql-python.sourceforge.net/MySQLdb.html

This topic created in 4313 days ago, the information mentioned may be changed or developed.

比如说表中有数据
101
105
112
201
202
501

查询后得出的结果是
112
105
101

202
201

501

这样的查询怎样些

3 replies • 2014-08-18 13:16:08 +08:00

1

mgc

Aug 18, 2014

1

ORDER BY LEFT(col, 1) DESC, ORDER BY col DESC

2

luckylion

OP

Aug 18, 2014

多谢,解决

3

sumarklee

Aug 18, 2014

需要分开写吗

About · Help · Advertise · Blog · API · FAQ · Solana · 1664 Online Highest 6679 ·

Select Language

创意工作者们的社区

World is powered by solitude

VERSION: 3.9.8.5 · 1166ms · UTC 16:37 · PVG 00:37 · LAX 09:37 · JFK 12:37
♥ Do have faith in what you're doing.