I have a plugin installed on one of my wordpress blogs that are using custom fields. Today I was experiencing an error on one of my blogs, so I wanted to check what was being inserted into the database for those fields.
WordPress custom fields are being stored in the wp_postmeta. The meta_key column for my plugin is syndication_permalink, so I ran the following query:
SELECT *
FROM wp_posts, wp_postmeta
WHERE wp_posts.ID = wp_postmeta.post_id
AND wp_postmeta.meta_key LIKE 'syndication_permalink'
AND wp_postmeta.meta_value LIKE '%lowcarbblogs%'
ORDER BY wp_posts.post_modified DESC