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 |
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 |