select tt.rowno from( select (@rownum:=@rownum+1) as rowno, t.id from news t ,(select (@rownum :=0) ) b where .....) tt where tt.id=503 转载于:https://www.cnblogs.com/yulouchun/p/8358004.html