Random Snippets

I was looking for a way to order the rows randomly in a MySQL query and the solution was not easy for me to come by. I am posting the solution here in hopes of helping others.

1
2
3
SELECT *
FROM my_table
ORDER BY RAND()

RAND() returns a random floating-point value but functions to randomly order the selection [...]

Let’s say you have the following table called votes that keeps track of how people voted and you want a query to count the number of votes for you instead of having to loop through all the rows with a counter in PHP.

person
vote

obama
yes

mccain
no

obama
yes

obama
no

mccain
yes

obama
yes

obama
yes

obama
no

mccain
no