lpiotrowski

ORDER BY RAND

Aug 6th, 2014
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.44 KB | None | 0 0
  1. SELECT title FROM bookmarks ORDER BY RAND() LIMIT 10;
  2.  
  3. SELECT t.*
  4. FROM (
  5. SELECT ROUND(RAND() * (
  6. SELECT MAX(id)
  7. FROM bookmarks)) num, @num:=@num+1
  8. FROM (
  9. SELECT @num:=0) AS a, bookmarks
  10. LIMIT 10) AS b, bookmarks AS t
  11. WHERE b.num = t.id;
  12.  
  13. SELECT * FROM bookmarks ORDER BY crc32(concat(CURRENT_TIMESTAMP, id)) LIMIT 10
  14.  
  15. SELECT a1.* FROM bookmarks a1
  16.     JOIN (SELECT id FROM bookmarks a2 ORDER BY RAND() LIMIT 10) aj
  17. WHERE a1.id = aj.id
Advertisement
Add Comment
Please, Sign In to add comment