samedi 24 juillet 2021

PHP MySQL Picking One Random Result From Each Date

I have a db structured like this:

int, date, varchar
1, 2021-07-25, aaaa
2, 2021-07-25, aaba
3, 2021-07-25, aabb
4, 2021-07-26, bbbb
5, 2021-07-26, bbba
6, 2021-07-26, bbaa
7, 2021-07-26, babb

I need to pull one result for each date at random. So one result for 07-25 and one result from 07-26 with this example.

Sample Output:

aaaa
bbbb

Thank you




Aucun commentaire:

Enregistrer un commentaire