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.
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.