To select a random row in MySQL you can use the following query.
Sample MySQL
SELECT COLUMNNAME FROM TABLENAME ORDER BY RAND() LIMIT 1
One thought on “How to select a random row in MySQL”
Leave a Reply
You must be logged in to post a comment.
All the Code Snippets and Samples you need
To select a random row in MySQL you can use the following query.
SELECT COLUMNNAME FROM TABLENAME ORDER BY RAND() LIMIT 1
You must be logged in to post a comment.
RT @CodeSnippetsNET: How to select a random row in #MySQL http://t.co/NCXblz5uTK #html #php #css #programming #js