初始化表结构drop table if exists `data`;create table `data` ( `dates` varchar(255) character set utf8 default null, `id` int(11) default null, `result` varchar(255) character set utf8 default null);insert into `data` (`dates`, `id`, `result`) values ('2015109101', 1, '胜');insert into `data` (`dates`, `id`, `result`) values ('2015110101', 2, '负');insert into `data` (`dates`, `id`, `result`) values ('2015109101', 3, '负');insert into `data` (`dates`, `id`, `result`) values ('2015109101', 4, '胜');insert into `data` (`dates`, `id`, `result`) values ('2015110101', 5, '胜');insert into `data` (`dates`, `id`, `result`) values ('2015109101', 6, '负');insert into `data` (`dates`, `id`, `result`) values ('2015109101', 7, '胜');insert into `data` (`dates`, `id`, `result`) values ('2015110101', 8, '负');
排序select @rownum:=@rownum+1 as rownum,id,dates from`data`,(select @rownum:=0) r order by dates;
结果
条件查询select rownum,idfrom (select @rownum:=@rownum+1 as rownum,id,dates from `data`,(select @rownum:=0) r order by dates)b where id =2;
结果
写在最后的话 获取你有更好的方法在mysql中来实现rownum()，欢迎不吝赐教。