[SOLVED] MySQL: SELECT UNIQUE VALUE

Issue

In my table I have several duplicates. Ineed to find unique values in mysql table column.

SQL

SELECT column FROM table
WHERE column is unique

SELECT column FROM table
WHERE column = DISTINCT

I’ve been trying to Google, but almost all queries are more complex.

The result I’s like is all non duplicate values.

EDIT
I’d like to have UNIQUE values…

Not all values one time… (Distinct)

Try to use DISTINCT like this:

SELECT DISTINCT mycolumn FROM mytable

EDIT:

Try

select mycolumn, count(mycolumn) c from mytable
group by mycolumn having c = 1

Answered By – Rahul Tripathi