Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Randomize a "zone" but not the whole table ...

Status
Not open for further replies.
Sleidia

Sleidia

Technical User
May 4, 2001
1,284
FR

Good morning to you all...

I am wondering if it is possible to do the following
with a MYSQL request:

Arbitrary picking a zone in a table (lets say from row 20 to row 50) and
getting a random row coming from this zone only.

I did ... ORDER BY RAND() LIMIT 20,30 ... , but of course it always
change the order of the whole table and then displays rows coming from
outside the pre-determined zone.

Thanks a lot for the one who will spend his precious time
to reply to this.

Have a nice day.
 
Status
Not open for further replies.

Similar threads

lupidol
  • Locked
  • Question
mysql cannot add rows with "UNION" 1
Replies
5
Views
427
Chris Miller
Chris Miller
boylesg
  • Locked
  • Question
Can't sort my table by a particular column, records are returned in autinc order.
Replies
4
Views
487
spamjim
spamjim
EdLentz
  • Locked
  • Question
Need to compare two tables and list the differences
Replies
3
Views
432
EdLentz
EdLentz
lupidol
  • Locked
  • Question
Cannot create new table in mySQL 3
Replies
6
Views
472
lupidol
lupidol
waubain
  • Locked
  • Question
mysqli_multi_query not not returning any results
Replies
2
Views
399
waubain
waubain

Part and Inventory Search

Sponsor

Back
Top