MYSQL从5个相同的值中只选择1个

Question

I want to get one value out of 5 which are the same, lets say 5 records have the same value in some column.

How do I only get one out of them and not 5 ?

Answer 1

Add DISTINCT to your query:

SELECT DISTINCT field FROM table;