Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT title FROM bookmarks ORDER BY RAND() LIMIT 10;
- SELECT t.*
- FROM (
- SELECT ROUND(RAND() * (
- SELECT MAX(id)
- FROM bookmarks)) num, @num:=@num+1
- FROM (
- SELECT @num:=0) AS a, bookmarks
- LIMIT 10) AS b, bookmarks AS t
- WHERE b.num = t.id;
- SELECT * FROM bookmarks ORDER BY crc32(concat(CURRENT_TIMESTAMP, id)) LIMIT 10
- SELECT a1.* FROM bookmarks a1
- JOIN (SELECT id FROM bookmarks a2 ORDER BY RAND() LIMIT 10) aj
- WHERE a1.id = aj.id
Advertisement
Add Comment
Please, Sign In to add comment