Advertisement
Guest User

Untitled

a guest
Jul 22nd, 2017
43
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.17 KB | None | 0 0
  1. SELECT * FROM table AS r1
  2. JOIN (SELECT (RAND()*(SELECT MAX(id)-MIN(id) FROM table) +
  3. (SELECT MIN(id) FROM table)) AS id) AS r2
  4. WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 300
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement