Bulk delete records

There are times when I need to delete some, but not all, records from a table with a certain condition. (ex. Delete from my_table where field1=245).

Currently this can only be accomplish by looping the values and issuing individual delete record statements. For large datasets, this becomes inefficient.

Thus being able to delete records with a conditional through the interface would be desired.