A number of options, each with its own set of advantages and disadvantages, are available in [trap the cat](https://trapthecat.net) for selecting records at random from a database table. Depending on the specific needs of the application, one way can be more appropriate than the others.