Deleting random rows from a table without knowing anything about the table ids

mysql, php, phpmyadmin

Solution

You can do:

DELETE FROM tbl
ORDER BY RAND()
LIMIT 20

See MySQL `DELETE` syntax

Problem

I'm having a problem in mysql. I want to delete 20 rows from a table containing 100+ records. I do not know the id's of the rows, any special identification of the rows to be deleted. I want to just delete the any random rows from my table. Please help me... i am new to this condition.

Original source