Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT name, number FROM table
- WHERE EXISTS (
- SELECT number FROM table
- WHERE number > 3
- )
- ORDER BY RAND()
- LIMIT 10
- (select * from your_table where number > 5 order by rand() limit 1)
- union all
- (select * from your_table limit 9 order by rand())
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement