Sql+mysql random Data read-Advanced related issues

---advanced problem of sql+mysql random data reading
For example, there is a table class, the data is a roster, such as name, age, gender, birthplace
I now want to get a random result: according to the place of origin, each province randomly lists a record. All the provinces in the roster are to be read.
How do I write this SQL statement?

------Solution--------------------
Select m.* from (SELECT * from User order by Rand ()) m GROUP by m.area_id

User is your table name, area_id is native

Problem solving.

If it is helpful to you, please help me to order my website advertisement, thank you.
Website: http://blog.72-web.com

