重复值条件选择PHP / mySQL

Question

I have a database with thousands of entries

"id" is the primary key

"event_description"

"event_time"

"location"

In a php script i need to select all rows from the table and if "locationXXX" appears in more than one row collect the various values for "event_description" paired with respective "event_time" and echo them as list items

if instead there are no duplicates then select it normally and echo the results

Altering table structure is an option but i'd rather not

Any help is highly appreciated

Answer 1

Assuming the table is called event

SELECT location, event_description, event_time
FROM event
GROUP BY location
HAVING COUNT(location) > 1;