MySQL GROUP BY order
===

Please consider the following table structure and data:

    +--------------------+-------------+
    |     venue_name     |  listed_by  |
    +--------------------+-------------+
    | My Venue Name      |      1      |
    | Another Venue      |      2      |
    | My Venue Name      |      5      |
    +--------------------+-------------+ 

I am currently using MySQL's `GROUP BY` function to select only unique venue names. However, this only returns the first occurance of `My Venue Name`, but I would like to return it based on a condition (in this case where the `listed_by` field has a value > 2.

Essentially here's some pseudo-code of what I'd like to achieve:

    Select all records
    Group by name
    if grouped, return the occurance with the higher value in listed_by

Is there an SQL statement that will allow this functionality?