Hi @trisham
I believe you can do it like this:
DELETE FROM wp_postmeta WHERE wp_postmeta.meta_key = "custom_field_name" OR wp_postmeta.meta_key = "_custom_field_name"
If you have time, please learn more about SQL here: http://www.w3schools.com/sql/.
Thanks!