Delete half of the records from MySQL database table [closed]

Question

I have a table with an unknown number of records. I want to delete half of the records. I don’t care which records are deleted. What’s the most efficient way to do it?

Answer 1

delete from some_table where rand() < 0.5;

This will delete about half the records, most of the time.