MySQL :: MySQL 5.6 Reference Manual :: 13.2.2 DELETE Syntax

I spent an hour or so working out how to delete rows matching a specific SELECT statement which was mildly complex: SELECT A.* FROM table1 AS A, table1 AS B WHERE A.username LIKE '%2' AND A.ID = B.ID AND A.username B.username (Basically, I ...

dev.mysql.com