Skip to content

Instantly share code, notes, and snippets.

@fomigo

fomigo/late row lookup in MySQL.sql

Forked from subbu/late row lookup in MySQL.sql
Created November 24, 2019 15:00
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save fomigo/b46a6e7035cdf80f4504ea36175d1478 to your computer and use it in GitHub Desktop.
Save fomigo/b46a6e7035cdf80f4504ea36175d1478 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
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
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment