subbu · March 29, 2011 17:06
diff --git a/late row lookup in MySQL.sql b/late row lookup in MySQL.sql
 SELECT  p.id, name, LENGTH(body) AS len
 FROM    (
        SELECT  id
        FROM    projects
        ORDER BY id
        LIMIT 150000, 10
        ) o
 JOIN    projects p
 ON      p.id = o.id
 ORDER BY p.id
	SELECT p.id, name, LENGTH(body) AS len
	FROM (
	SELECT id
	FROM projects
	ORDER BY id
	LIMIT 150000, 10
	) o
	JOIN projects p
	ON p.id = o.id
	ORDER BY p.id