Home › Forums › Add-ons › Repeater Field › Deleting field data manually from DB › Reply To: Deleting field data manually from DB
Old question, but for anyone that’s looking to delete data from the database
Standard field names including top level repeaters and other fields with sub fields, there are two fields that need to be deleted
$field_name
'_'.$field_name
for repeater and other sub fields
$repeater.'_'.$row.'_'.$sub_field
'_'.$repeater.'_'.$row.'_'.$sub_field
for nested repeaters
$repeater.'_'.$row.'_'.$nested_repeater.'_'.$row.'_'.$sub_field
'_'.$repeater.'_'.$row.'_'.$nested_repeater.'_'.$row.'_'.$sub_field
the above continues with each nesting level
the following like value will remove all of the fields and sub fields, be careful with collisions with other fields, back up your DB first.
DELETE FROM wp_postmeta WHERE meta_key LIKE '%'.$field\_name.'%';
You should escape underscores as it is a character in SQL that stands for any one character. field_name
and fieldXname
will both be removed if you do not escape the _
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
We use cookies to offer you a better browsing experience, analyze site traffic and personalize content. Read about how we use cookies and how you can control them in our Privacy Policy. If you continue to use this site, you consent to our use of cookies.