MySQL select random 10 rows from 5 -


i need take 10 rows table. has random in table have 5 rows. , if select:

select * `names` order rand() limit 10 

but query returns me 5.

how 5 more repeat?

select m.* names m,names n order rand() limit 10

this may wanted


Comments

Popular posts from this blog

Android layout hidden on keyboard show -

google app engine - 403 Forbidden POST - Flask WTForms -

c - Why would PK11_GenerateRandom() return an error -8023? -