Hello Everyone,
I'm facing a problem since last night, actually I want to select records from MySQL table randomly. So please tell me whether any option in MySQL database to perform this action.
Please reply as soon as possible.
Technology
Web App Development
Mobile App Development
Windows App Development
Database Development
UI/UX Development
Cloud Development
SEO
Digital Marketing
Guest Posting
Content Writing
Artificial Intelligence
Data Science
ERP Development
CRM Development
CMS Development
LMS Development
Business Listing
Blockchain Technology
Startup Promotion
AI Tools Integration
To select record from MySQLdatabase randomly, you can use ORDER BY RAND() function. This function returns table values randomly. You can use this as follows.
Query: SELECT * FROM `table` ORDER BY RAND() ;
You can also use this query to perform this action.
Query: SELECT * FROM `table` ORDER BY RAND() LIMIT 2;
where limit is used for random id limit.
I hope this solution might be helpful for you.