19

I am using the advanced custom fields plugin for posts. I would like to know where custom fields are stored. I checked the wp_posts table. However, I could not find the posts with custom fields. I would like to know in which table are they stored in database.

1
  • Hello @ChetanaKestikar - since ACF is not actually a part of WordPress, it's difficult to say where it stores data without a great deal of knowledge regarding the inner workings of the plugin. For that reason, your question would be best addressed in the official ACF support channels.
    – bosco
    Mar 25, 2017 at 2:49

2 Answers 2

28

From the codex for custom fields:

The PostMeta information is stored in a new table, $wpdb->postmeta. This table has four fields:

'meta_id' - A unique id for each entry.
'post_id' - The ID of the post for this metadata.
'meta_key' - The name of the 'key'.
'meta_value' - The value associated with the key.

This of course assumings that ACF uses the default WordPress stucture and not a custom database.

5
0

How do we know which ACF field is unused vs used?

This info for a custom field was listed in the "meta_value" field does this mean that there is associated content? It was a relationship field in ACF

a:2:{i:0;s:5:"11637";i:1;s:5:"11463";}

1
  • 2
    If you have a new question, please ask it by clicking the Ask Question button. Include a link to this question if it helps provide context. - From Review
    – cjbj
    Dec 13, 2022 at 19:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.