MySQL distinct Get values without duplicates: SELECT DISTINCT comment_author_email FROM wp_comments; "wp_comments" table: id comment_author_email 1 a@mail.com 2 b@mail.com 3 a@mail.com Result after select: a@mail.com b@mail.com