Cacher is the code snippet organizer for pro developers

<?php

$q = db_select('flood','f');
$q->fields('f', array('event', 'identifier'));
$a = $q->execute()->fetchAll();
dsm($a);

db_delete('flood')
->condition('event', 'user_register')
->execute();