Ramdom results?

[Elhombrebala]

I have a DB in which one table has info about cities, I would like to query the table in order to choose ramdomly one of the cities and show the info.
Any hints?

Merry Christmas to everyone and peace one day!😉

[njm]

You can use the MySQL RAND() function

SELECT city FROM table ORDER BY RAND() LIMIT 1;

hth, njm