I have the following table:
ID Job Category 1 Clerk Admin 2 Secretary Admin 3 Reception Admin 4 Typist Admin
Now, I want to display 5 jobs within the Admin Category, but I want them pulled randomly from the database. ORDER BY RAND won't work because there are only 4 records. I need to display 5 records as it doesn't matter if the same record is displayed more than once. How do I do this?