Select Random Records in MySQL
Selecting random records from a table is helpful when showing items with no preferences or testing different result sets. The following SQL defines a table holding images. Imagine that we wish to pick up 10 random rows from it. In …