Distinct operator in mysql

Distinct operator is used when we want unique value in the column.

mysql> SELECT DISTINCT columnname FROM tablename