SELECT a random row with SQLSELECT a random row with SQL Updated on February 26, 2024 By Pete Freitag There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax. Select a random row with MySQL: SELECT column FROM table ORDER BY RAND() LIMIT 1 Select a random row with
