Delete all custom fields at once?

You can use the SQL way. Go in your database tool, like phpMyAdmin or Adminer (also possible via Plugin in the WordPress back-end). Use the SQL area for creating custom queries.

Before you start, create a backup of the database and also a single backup for the table _postmeta.

Change the string wpbeta_2 to your prefix, this is only a example.

Get all fields that have a custom field:

SELECT *  FROM `wpbeta_2_postmeta` WHERE `meta_key` != ''

Now you have a list of all fields, check this.

Delete a specific field:

DELETE FROM `wpbeta_2_postmeta` WHERE `meta_key` = 'modules'

Delete all fields:

DELETE FROM `wpbeta_2_postmeta` WHERE `meta_key` != ''

Related Posts:

  1. How to filter post listing (in WP dashboard posts listing) using a custom field (search functionality)?
  2. Add validation and error handling when saving custom fields?
  3. Validating Custom Meta Box Values & Required Fields
  4. Is there a way to set default custom fields when creating a post?
  5. Add custom objects/entities to WordPress
  6. Adding another state (spam, reject, approve) to wordpress comments?
  7. Edit Custom Database Tables in WordPress
  8. Filter results with custom field values and dropdown
  9. Meta keywords and descriptions plugin for manually editing meta for each page/post
  10. Making a configurable field translatable
  11. Is there a way to do multiple ordering on a multiple meta_query?
  12. Check before publishing, if already exist post with current custom field value
  13. How to customize default wordpress editor?
  14. Custom Fields Bulk Edit
  15. Custom Page Template [closed]
  16. How to make custom comment fields required and message field not required
  17. Problem in custom meta boxes
  18. How to show custom field’s value under post/page title in wp-admin
  19. Multiplile values checkbox or select in custom meta box
  20. Adding Properties to User Profile and Displaying in List
  21. ajax delete value from custom field array
  22. How do I read the value of a custom field of the page?
  23. how to save multiple custom fields for a post in one go?
  24. get_post_meta in sitewide tags plugin fails to return value for custom fields
  25. Best way to add custom / magic / flutter fields into RSS feed
  26. Insert attachment ID in custom field from media uploader
  27. How do you create dynamic customised sections in WordPress?
  28. Buddypress Add unserialized Profile Fields in Members Loop [closed]
  29. Better Method for Multiple Meta Boxes
  30. query usermeta from custom field
  31. custom avatar removal
  32. Displaying a checkbox array from advanced custom field
  33. WP 3.1 meta_query for multiple custom field values
  34. How to make condition, based on custom fields value?
  35. How to select posts from multiple categories and metavalues?
  36. Sort custom field by post
  37. Send email with custom fields after new draft is saved or new post published
  38. How do i add custom fields to my themes template file?
  39. Custom tables or custom fields?
  40. Post selector as Custom Field
  41. I need a “Choose from existing content” popin
  42. For homepage images (for small business website), is it better to use custom fields or post_thumbnail?
  43. How to remove custom fields from the selector?
  44. How can I hide custom field from users used for caching response from external api?
  45. How to query an out put value?
  46. Check & remove special characters in a field?
  47. Let’s Create Custom Field Template Documentation
  48. How can I combine this php statement to get the results of multiple variable inputs?
  49. frontend submit post jQuery clone row won’t save
  50. Is there a way to set default custom fields when creating a new post?
  51. MetaBox not saving after empty
  52. Get text from user and display it on page
  53. Custom Fields Question
  54. Showing Custom Fields on Parent Page
  55. How can I output the custom fields wrapping with HTML
  56. Custom meta boxes not saving
  57. How to get all custom fields with some prefix in key?
  58. Best way to achieve multiple links in a post title
  59. WP-eComerce Advance Meta Tag data in descending order [closed]
  60. Meta Box Plugin Cloned Fields – Multiple Foreach values
  61. Searching with Multiple (Parallel) Criteria on Custom Fields?
  62. Save custom field types with this function…?
  63. Make separate text boxes for separate WordPress Custom Fields
  64. Custom field bug in WordPress 3.2
  65. How to sort post listing on a page using custom field value?
  66. Adding re-type email and check it if the email match
  67. Odd functions.php issue in WordPress
  68. Counting post fields
  69. Approach to creating a site with this structure
  70. Save input form on custom field
  71. Delete custom fields on post publish?
  72. When post is updated, custom metadata in text area field is overwritten
  73. Adding custom fields to images
  74. Is it possible in WordPress
  75. Extend WP_Customize_Control with Multiple Field Control
  76. custom field functionality
  77. Custom fields are not displaying in page with multiple loops
  78. How to add an option to admin to add image that could be used as header?
  79. Show or hide lang=”ur” in main element
  80. How can I create more “create attachment” custom field – any idea?
  81. Using Hooks. Thematic
  82. Adding thumbnails for non-image attachments
  83. Custom field in a shortcode?
  84. How to add a prefix to existing custom fields over MYSQL query?
  85. I would like to display different text on different pages
  86. Semi-Private Comments + page comments -> is it possible?
  87. Add image custom attribute [closed]
  88. Check if a field is capitalized?
  89. How I can change PayPal IPN ‘custom’ field in woocommerce?
  90. Problem display
  91. Google not index my Custom 404 page ?why?
  92. Add fields to edit in custom widget
  93. Matching Serialized Arrays with meta_query
  94. Looping inside block return
  95. Sortable Custom Columns not sorting correct
  96. Is there a size limit to the value you can save in a custom field?
  97. Custom Theme Fields in Settings Menu – apply filters to one of those fields?
  98. multiple meta_query and orderby question
  99. Related post thumbnail not showing up
  100. How do i get a specific user metadata using custom metavalue outside of wordpress?