Delete a custom field in mysql for all posts with specific category id
I am trying to delete all custom fields with the key 'key1' from posts that are in category id '66'.
I can delete all custom fields with the key 'key1' with the following mysql query:
wp_postmeta WHERE meta_key = 'key1'
How do I specify the category in that query?