How do I delete all but most recent record?

[dump3]

I've been struggling with a problem trying to purge out a huge log table. Each record has many fields, but I want to delete all but the most recent entry based on the name field, ip_address field, and date field (containing unixtime).

Specifically, I want to do something like:

DELETE from log_table where name AND ip_address are unique except for where date is the largest value

Keeping in mind multiple names can use the same ip_address.

I'd greatly appreciate any help. :)