Yes - `delete from posts where published = 1;` (or however your particular database adapter translates true)