How to remove the following duplicate rows mysql?

Question

PHP

How to edit the code so that the next duplicate entries are removed.
Should be like this:
id_user | id_post
2 | 16
4 | 12
1 | 25

There is the following code

SELECT `id_user`, `id_post` FROM `posts`
ORDER BY RAND()
LIMIT 10

Answer 1

SQL DISTINCT statement