mysql 中英文排序让数字排在字母后面，字母与数字均为正序排列

废话不多说，直接上demo

DROP TABLE IF EXISTS `test`;
CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `names` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8;
INSERT INTO test  (names) VALUES('12'),('aaa'),('dsds'),('sss'),('ccc'),('3223');

select * from test order by names REGEXP '^[0-9]', convert(names USING gbk);