sql query rank math options

#216578
  • Resolved Kenneth Gervacio
    Rank Math free

    How to edit SEO Titles & META Settings using sql query?
    I have 2 website, 1 is the main and the other is a mirror of main site but different link.
    I usually do import and export database and I need to manually update the SEO Titles & META on wp-admin to change maindomain.com to mirrordomain.com

    Thanks!

Viewing 3 replies - 1 through 3 (of 3 total)
  • Brian
    Rank Math free

    Hello,

    Thank you for contacting Rank Math today.

    Could you be having any specific settings that you would wish to update from your DB?

    For instance you can update the robots options of page by using this query:
    UPDATE wp_postmeta SET meta_value='a:1:{i:0;s:5:"index";}' WHERE meta_key='rank_math_robots'

    You might need to change wp_ prefix in the wp_postmeta table name.

    Hope that helps and please do not hesitate to let us know if you need our assistance with anything else.

    Hi Brian

    I want to update what I set on wp-admin/admin.php?page=rank-math-options-titles which are Homepage Title, Page, etc using sql query.

    Thanks for fast response and sorry If I’m not being clear.

    Hello,

    Thanks for getting back. Sorry for the delay and any inconvenience that might have been caused due to that.

    You can use the rank_math_title and rank_math_description fields to achieve that. Here is a sample query for the reference:

    UPDATE wp_postmeta SET
     meta_id = '24',
     post_id = '1',
     meta_key = 'rank_math_title',
     meta_value = '%title% %currentmonth%'
    WHERE meta_id = '24';

    You can also use the Bulk Editing options to edit the title and description in bulk. Here is a guide with the step by step instructions: https://rankmath.com/kb/bulk-editing-in-rank-math/

    Hope this helps. Let us know if you need any further assistance.

    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.

Viewing 3 replies - 1 through 3 (of 3 total)

The ticket ‘sql query rank math options’ is closed to new replies.