How to delete received data?

Question

MySQL

I get data with the following query:

SELECT id,title_ru FROM `date` GROUP BY title_ru HAVING COUNT(*)>1

Here's what comes up:
I need to remove them, how do I do that? DELETE with GROUP BY Not working

Answer 1

SELECT FROM `date` where id in (SELECT id FROM `date` GROUP BY title_ru HAVING COUNT(*)>1)