For the example here we will use the table NAMES and I need 3 rows returned.
id | name |
---|---|
1 | Alpha |
2 | Beta |
3 | Chi |
4 | Delta |
5 | Epsilon |
I know the code SELECT * FROM names ORDER BY RAND() LIMIT 3;
will return 3 randomized rows. But it is exclusively three different rows.
Is there a way to in a query get three rows that do not influence each other, and thus allow for repetion? So a result could be Beta, Alpha, Delta. Or Beta, Epsilon, Beta, or even Beta, Beta, Beta.
Aucun commentaire:
Enregistrer un commentaire