Hello,
Thank you for contacting us.
The Rank Math title/SEO title is stored in the wp_postmeta table with the meta_key as rank_math_title.
However, as you mentioned in the sensitive data section that you’re using the premium model of Rank Math, assuming you’re referring to Rank Math PRO, could you share the email ID you used to purchase the PRO subscription so that we can locate your account and suggest a better and easier approach to this?
Looking forward to helping you.
Thank you.
i tried using
SELECT
wp_posts.post_title AS ‘Title’,
wp_postmeta.meta_key AS ‘Name’,
but its returning Unknown column ‘wp_postmeta.meta_key’ in ‘fiel
d list’
i think im missing crucial join statement, can you help me out. this is what im trynna do
SELECT
wp_posts.post_title AS ‘Title’,
wp_posts.post_name AS ‘Name’,
wp_postmeta.meta_key AS ‘Seo Title’,
wp_terms.name AS ‘Category’
FROM
wp_posts
INNER JOIN wp_term_relationships ON wp_posts.ID = wp_term_relationships.object_id
INNER JOIN wp_terms ON wp_term_relationships.term_taxonomy_id = wp_terms.term_id
INNER JOIN wp_term_taxonomy ON wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id
WHERE
wp_posts.post_status = 'publish'
AND wp_posts.post_type = 'post'
AND wp_term_taxonomy.taxonomy = 'category'
AND wp_posts.post_title LIKE '%2021%'
ORDER BY
wp_posts.post_date DESC;
Hello,
The entry is called rank_math_title and that’s the meta_key value, so you should look inside that table for the meta key with that name and not look directly for the word meta_key.
Hope this helps clarify your doubts.
Don’t hesitate to get in touch if you have any other questions.
Hello,
Since we did not hear back from you for 15 days, we are assuming that you found the solution. We are closing this support ticket.
If you still need assistance or any other help, please feel free to open a new support ticket, and we will be more than happy to assist.
Thank you.
