MySQL - Select specific rows and only then randomize them

Question

When I write 'SELECT * FROM table ORDER BY RAND() LIMIT 50' mysql has to randomize the entire table then only fetch 50. What I want to do (in mysql, preferably not in php) is to fetch 50 rows THEN randomize them.

Is there a way to do this in Mysql?

Adriaan Stander · Accepted Answer · 2009-12-12 12:42:20Z

3

Have you tried something like this

SELECT *
FROM    (
            SELECT * 
            FROM table 
            LIMIT 50
        ) sub
ORDER BY RAND()

answered Dec 12, 2009 at 12:42

Adriaan Stander

167k32 gold badges294 silver badges288 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gal Over a year ago

doesn't work. it says: "every derived table has to have its own alias"

Gal Over a year ago

oh I just needed to provide it an alias after the closing brace.

Collectives™ on Stack Overflow

MySQL - Select specific rows and only then randomize them

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related