4 ms·

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