web-profile

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

Leave a Reply

Your email address will not be published.