Randomize x through y rows in a MYSQL database

Question

For example, how can I randomize rows ten through 20? I only know how to randomize all rows using RANDR(). I am using PHP + MYSQLi. Can someone explain me using MYSQL RANDR() ? I know it's not efficient.

Thanks, Tom.

Answer 1

I have used a technique with SQL Server that might port to MYSQL. I assign a new GUID to each row, then sort on that.