MySQL: Exclude double Values from Search Result

You can work with the keyword DISTINCT, for example.

In order to read out all different cities and names and to prevent duplicate entries in the search result, you can write the following:

SELECT DISTINCT city FROM tab;
SELECT DISTINCT name FROM tab;

SELECT DISTINCT is also working over multiple columns. You can use that for example, if you also want to read out the postal code for each town:

SELECT DISTINCT postalcode, city FROM tab;

Another approach is to work with GROUP BY:

SELECT COUNT(id), city FROM tab GROUP BY city;

With this query, we are counting how often each city is appearing in the table and we are showing the number as well as the name of the city in the result.
Last update on 2021-05-04 | Created on 2016-02-13