Oracle分页时的Rownum转换成Mysql

Oracle：

select * from (
select rownum as num,a.* from (
select * from zjfx_book_mark order by to_number(id) ) a 
where rownum <= 20) 
where num > 10  

 

MySQL：

select d.* from (
select cast(@ROW :=@ROW + 1 as SIGNED) AS NUM,c.* from (
select b.* from zjfx_book_mark b order by cast(id as SIGNED)) c 
left join (SELECT @ROW := 0) r ON 1 = 1) d limit 10,10