Select those who doesn't repeat

Question

How to select like if I have columns with rows

column
row1
row1
row2
row3
row3

And when outputting all rows, only to output like..

row1
row2
row3

If there is rows with same value, I want to output them just once.

Answer 1

Either use

SELECT DISTINCT(column) FROM TABLE

or

SELECT column FROM TABLE
GROUP BY column

Answer 2

SELECT DISTINCT `fieldname` FROM `mytable`