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
Post a Comment