Select random records using ORDER BY RAND() in MySQL - MySQL Developer Tutorial

Select random records using ORDER BY RAND() in MySQL 

Scenario : 

Let's say you are working as MySQL Developer and you are asked to provide some sample data from a table. You need to provide 10 rows or 100 rows but they should be selected random from table.

Solution : 

You can use Rand ( ) function with Limit to get RANDOM ROWS from table. By using Limit you will restrict the number of rows you want to return.

Select * from YourTableName Order by RAND() Limit Count;

Let's say if we want to get 10 Random rows from customer table, we can use below statement in MySQL or MairaDB.

Select * from customer order by RAND () Limit 10;


  1. Do you need Personal Finance?
    Business Cash Finance?
    Unsecured Finance
    Fast and Simple Finance?
    Quick Application Process?
    Finance. Services Rendered include,
    *Debt Consolidation Finance
    *Business Finance Services
    *Personal Finance services Help
    contact us today and get the best lending service
    personal cash business cash just email us below
    Contact Us:
    call or add us on what's app +918929509036

  2. This is a really good site. I really like this sss online registration. Thank you for sharing this wonderful information.
    Learn more about services and how to get started.