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


    for repeater and other sub fields


    for nested repeaters


    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 _