title: Delete entries from a table and store a value from the deleted entries
body: <p>I have a table set up with the names of all the files in a directory.  I want to be able to delete all the files that have a specific property from both the table and the directory.  For example, if the entry does not have a <code>name</code> then I want to delete it.  The sql statement I thought about using would be <code>delete from master where name = null</code> but then I wouldn't be able to delete the file from the directory because I would have no way to determine which file to delete.  Is there a way to store the values from the entries in the table in an array before I delete them?</p>