เปลี่ยน URLs ของ wordpress ใน Database

How to Change/Update links with MySQL

You can use the MySQL replace command to search and replace text inside database tables.

For updating the URL we need to run the below query over multiple tables and fields.

update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, ‘find string’, ‘replace string’);

 

  • Open the PHPMyAdmin panel and log in.
  • Click the WordPress database.
  • For replacing the URL across all database tables, Click on SQL tab and in the panel type the below code:
    UPDATE wp_options SET option_value = replace(option_value, 'Existing URL', 'New URL') WHERE option_name = 'home' OR option_name = 'siteurl';
    
    UPDATE wp_posts SET post_content = replace(post_content, 'Existing URL', 'New URL');
    
    UPDATE wp_postmeta SET meta_value = replace(meta_value,'Existing URL','New URL');
    
    UPDATE wp_usermeta SET meta_value = replace(meta_value, 'Existing URL','New URL');
    
    UPDATE wp_links SET link_url = replace(link_url, 'Existing URL','New URL');
    
    UPDATE wp_comments SET comment_content = replace(comment_content , 'Existing URL','New URL');

 

  • If you have images linked in your posts then you need to run the following additional queries.
    • For images inside posts
      UPDATE wp_posts SET post_content = replace(post_content, 'Existing URL', 'New URL');
    • For images linked in old link manager
      UPDATE wp_links SET link_image = replace(link_image, 'Existing URL','New URL');
    • For images linked as attachments
      UPDATE wp_posts SET guid = replace(guid, 'Existing URL','New URL');

 

  • The above queries run for default tables that as discussed above are known to contain URL entries in WordPress. You may also need to add other tables which are not default with WordPress.
  • Click the ‘Go’ button.
  • The Existing URL would be updated site-wide to the new URL.

หรือเอาให้ง่ายๆเลย > https://rudrastyh.com/tools/sql-queries-generator

Leave a Reply

iameveme