{"id":26593,"date":"2016-06-10T23:01:16","date_gmt":"2016-06-10T15:01:16","guid":{"rendered":"https:\/\/www.hongkiat.com\/blog\/?p=26593"},"modified":"2022-10-18T20:12:24","modified_gmt":"2022-10-18T12:12:24","slug":"mass-find-replace-database-wp","status":"publish","type":"post","link":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/","title":{"rendered":"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way"},"content":{"rendered":"<p>There are several occasions where we have to <strong>change URLs in our WordPress website database<\/strong>. For instance, we need to do this after migrating a WordPress database from one site, e.g. from the <code>http:\/\/acme.com<\/code> remote production site, to the <code>http:\/\/acme.dev<\/code> local development website on our computer.<\/p>\n<p>WordPress.org hosts a great number of plugins, such as <a href=\"https:\/\/wordpress.org\/plugins\/wp-dbmanager\/\" target=\"_blank\" rel=\"noopener\">WP DBManager<\/a> and <a href=\"https:\/\/wordpress.org\/plugins\/wp-migrate-db\/\" target=\"_blank\" rel=\"noopener\">WP Migrate DB<\/a>, and there are also a number of 3rd party tools that allow you to <strong>import database<\/strong> easily. The tricky part is having to <strong>change every URL instance<\/strong> inside the database.<\/p>\n<p>After migrating the database, URLs inside of it <strong>still point to the old site<\/strong>, in this case to <code>acme.com<\/code>. You may find the old URL in the <code>wp_options<\/code> table, set as the value of the <code>siteurl<\/code> and <code>home<\/code> options, and it\u2019s probably also embedded throughout several other rows and tables in the database. These old URLs may eventually prevent your site from running properly, so you need to <strong>change them to the new URL<\/strong>, in our example to <code>acme.dev<\/code>.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg\" height=\"430\" width=\"700\" alt=\"Sequel Pro database interface in OS X\"><figcaption class=\"entry-image-caption\">IMAGE: Sequel Pro, searching database value<\/figcaption><\/figure>\n<p>At this point, accessing our development site at <code>acme.dev<\/code> will simply lead <strong>to a blank page<\/strong>.<\/p>\n<p>So how do we change all these URLs in the database?<\/p>\n<h2>Running an SQL Query<\/h2>\n<p>Usually, people would run the following SQL Query which replaces the values of the <code>siteurl<\/code> and <code>home<\/code> options in the <code>wp_options<\/code> table.<\/p>\n<pre>\r\nUPDATE wp_options SET option_value =\r\nreplace(option_value, 'http:\/\/acme.com', 'http:\/\/acme.dev')\r\nWHERE option_name = 'home' OR option_name = 'siteurl';\r\n<\/pre>\n<p>Subsequently, they use another SQL Query to replace all URL occurrences in the <code>wp_posts<\/code> table, namely in the <code>post_content<\/code> column of each row.<\/p>\n<pre>\r\nUPDATE wp_posts SET post_content =\r\nreplace( post_content, 'http:\/\/acme.com', 'http:\/\/acme.dev' );\r\n<\/pre>\n<p>Running these queries is a workable solution, yet at the same time, is not convenient to do. It could be even nerve-wracking, seeing how the database may turn haywire due to a simple oversight within the query.<\/p>\n<h2>Leveraging WP-CLI<\/h2>\n<p>Another route we can do, and which I\u2019ve found to be a more handy alternative, is by <strong>leveraging the WP-CLI command line<\/strong>. This means you will need <a href=\"https:\/\/wp-cli.org\/#install\" target=\"_blank\" rel=\"noopener\">to have WP-CLI installed<\/a>.<\/p>\n<p>Assuming you have installed WP-CLI and have the <code>wp<\/code> command accessible as the alias, navigate to the directory where your WordPress site files reside.<\/p>\n<p>Then, run the following command:<\/p>\n<pre>wp search-replace 'http:\/\/acme.com' 'http:\/\/acme.dev<\/pre>\n<p>The first parameter, <code>'http:\/\/acme.com'<\/code>, is the old entry to be replaced with the second one, <code>'http:\/\/acme.dev'<\/code>.<\/p>\n<figure><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/\/wordpress-database-sql-wpcli-replace.jpg\" height=\"800\" width=\"700\" alt=\"WP-CLI table report for Search and Replace operation.\"><\/figure>\n<p>The command line will search through <strong>all the tables within the database<\/strong>, not only the <code>post_content<\/code> column and <code>wp_options<\/code> table, and <strong>replace every instance<\/strong> of the entry passed through the parameters of the command.<\/p>\n<p>As you can see from the above screenshot, a total of 225 replacements have been made. And we have done it through a simple line of command.<\/p>\n<p>I think it is worth mentioning that we can use the <code>wp search-replace<\/code> command, not only for replacing URLs, but any piece of <em>value<\/em> stored in the database as well. We can also limit the operation into a certain table by passing the table name as the fourth parameter, as follows:<\/p>\n<pre>wp search-replace '.jpg' '.webp' wp_posts<\/pre>\n<p>Running the above command, it will only search through <code>wp_posts<\/code>, the table that stores our content \u2013 posts, pages, etc. \u2013 and replace the image extension from <code>.jpg<\/code> to <code>.webp<\/code>.<\/p>\n<p class=\"note\"><strong>Recommended Reading:<\/strong> <a target=\"_blank\" href=\"https:\/\/www.hongkiat.com\/blog\/webp-guide\/\" rel=\"noopener\">Complete guide to using WebP image format<\/a><\/p>\n<p>WP-CLI makes a tangled SQL operation look more intuitive, and you can work with it in a more convenient way. If you want to fine-tune your commands, have a look at WP-CLI\u2019s documentation, that provides you with a <a href=\"https:\/\/wp-cli.org\/commands\/search-replace\/#options\" target=\"_blank\" rel=\"noopener\">list of options<\/a> to perform a more advanced operation with the <code>wp search-replace<\/code>command.<\/p>","protected":false},"excerpt":{"rendered":"<p>There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress database from one site, e.g. from the http:\/\/acme.com remote production site, to the http:\/\/acme.dev local development website on our computer. WordPress.org hosts a great number of plugins, such as&hellip;<\/p>\n","protected":false},"author":113,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[49],"tags":[4663,3053,252],"topic":[4520],"class_list":["entry-content","is-maxi"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v22.8 (Yoast SEO v27.6) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way<\/title>\n<meta name=\"description\" content=\"There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way\" \/>\n<meta property=\"og:description\" content=\"There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/\" \/>\n<meta property=\"og:site_name\" content=\"Hongkiat\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hongkiatcom\" \/>\n<meta property=\"article:published_time\" content=\"2016-06-10T15:01:16+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-18T12:12:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg\" \/>\n<meta name=\"author\" content=\"Thoriq Firdaus\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@tfirdaus\" \/>\n<meta name=\"twitter:site\" content=\"@hongkiat\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Thoriq Firdaus\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/\"},\"author\":{\"name\":\"Thoriq Firdaus\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/e7948c7a175d211496331e4b6ce55807\"},\"headline\":\"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way\",\"datePublished\":\"2016-06-10T15:01:16+00:00\",\"dateModified\":\"2022-10-18T12:12:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/\"},\"wordCount\":559,\"commentCount\":3,\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/mass-find-replace-database-wp\\\/wordpress-database-sql.jpg\",\"keywords\":[\"ad-divi\",\"Command Line\",\"WordPress Tips\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/\",\"name\":\"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/mass-find-replace-database-wp\\\/wordpress-database-sql.jpg\",\"datePublished\":\"2016-06-10T15:01:16+00:00\",\"dateModified\":\"2022-10-18T12:12:24+00:00\",\"description\":\"There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#primaryimage\",\"url\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/mass-find-replace-database-wp\\\/wordpress-database-sql.jpg\",\"contentUrl\":\"https:\\\/\\\/assets.hongkiat.com\\\/uploads\\\/mass-find-replace-database-wp\\\/wordpress-database-sql.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/mass-find-replace-database-wp\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"name\":\"Hongkiat\",\"description\":\"Tech and Design Tips\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#organization\",\"name\":\"Hongkiat.com\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"contentUrl\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/wp-content\\\/uploads\\\/hkdc-logo-rect-yoast.jpg\",\"width\":1200,\"height\":799,\"caption\":\"Hongkiat.com\"},\"image\":{\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/hongkiatcom\",\"https:\\\/\\\/x.com\\\/hongkiat\",\"https:\\\/\\\/www.pinterest.com\\\/hongkiat\\\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/#\\\/schema\\\/person\\\/e7948c7a175d211496331e4b6ce55807\",\"name\":\"Thoriq Firdaus\",\"description\":\"Thoriq is a writer for Hongkiat.com with a passion for web design and development. He is the author of Responsive Web Design by Examples, where he covered his best approaches in developing responsive websites quickly with a framework.\",\"sameAs\":[\"https:\\\/\\\/thoriq.com\",\"https:\\\/\\\/x.com\\\/tfirdaus\"],\"jobTitle\":\"Web Developer\",\"url\":\"https:\\\/\\\/www.hongkiat.com\\\/blog\\\/author\\\/thoriq\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way","description":"There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/","og_locale":"en_US","og_type":"article","og_title":"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way","og_description":"There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress","og_url":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/","og_site_name":"Hongkiat","article_publisher":"https:\/\/www.facebook.com\/hongkiatcom","article_published_time":"2016-06-10T15:01:16+00:00","article_modified_time":"2022-10-18T12:12:24+00:00","og_image":[{"url":"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg","type":"","width":"","height":""}],"author":"Thoriq Firdaus","twitter_card":"summary_large_image","twitter_creator":"@tfirdaus","twitter_site":"@hongkiat","twitter_misc":{"Written by":"Thoriq Firdaus","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#article","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/"},"author":{"name":"Thoriq Firdaus","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/e7948c7a175d211496331e4b6ce55807"},"headline":"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way","datePublished":"2016-06-10T15:01:16+00:00","dateModified":"2022-10-18T12:12:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/"},"wordCount":559,"commentCount":3,"publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg","keywords":["ad-divi","Command Line","WordPress Tips"],"articleSection":["WordPress"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/","url":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/","name":"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way","isPartOf":{"@id":"https:\/\/www.hongkiat.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#primaryimage"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#primaryimage"},"thumbnailUrl":"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg","datePublished":"2016-06-10T15:01:16+00:00","dateModified":"2022-10-18T12:12:24+00:00","description":"There are several occasions where we have to change URLs in our WordPress website database. For instance, we need to do this after migrating a WordPress","breadcrumb":{"@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#primaryimage","url":"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg","contentUrl":"https:\/\/assets.hongkiat.com\/uploads\/mass-find-replace-database-wp\/wordpress-database-sql.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.hongkiat.com\/blog\/mass-find-replace-database-wp\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.hongkiat.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Mass Find &amp; Replace WordPress Databases &ndash; The Easy Way"}]},{"@type":"WebSite","@id":"https:\/\/www.hongkiat.com\/blog\/#website","url":"https:\/\/www.hongkiat.com\/blog\/","name":"Hongkiat","description":"Tech and Design Tips","publisher":{"@id":"https:\/\/www.hongkiat.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.hongkiat.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.hongkiat.com\/blog\/#organization","name":"Hongkiat.com","url":"https:\/\/www.hongkiat.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","contentUrl":"https:\/\/www.hongkiat.com\/blog\/wp-content\/uploads\/hkdc-logo-rect-yoast.jpg","width":1200,"height":799,"caption":"Hongkiat.com"},"image":{"@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hongkiatcom","https:\/\/x.com\/hongkiat","https:\/\/www.pinterest.com\/hongkiat\/"]},{"@type":"Person","@id":"https:\/\/www.hongkiat.com\/blog\/#\/schema\/person\/e7948c7a175d211496331e4b6ce55807","name":"Thoriq Firdaus","description":"Thoriq is a writer for Hongkiat.com with a passion for web design and development. He is the author of Responsive Web Design by Examples, where he covered his best approaches in developing responsive websites quickly with a framework.","sameAs":["https:\/\/thoriq.com","https:\/\/x.com\/tfirdaus"],"jobTitle":"Web Developer","url":"https:\/\/www.hongkiat.com\/blog\/author\/thoriq\/"}]}},"jetpack_featured_media_url":"https:\/\/","jetpack_shortlink":"https:\/\/wp.me\/p4uxU-6UV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/26593","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/users\/113"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/comments?post=26593"}],"version-history":[{"count":4,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/26593\/revisions"}],"predecessor-version":[{"id":60377,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/posts\/26593\/revisions\/60377"}],"wp:attachment":[{"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/media?parent=26593"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/categories?post=26593"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/tags?post=26593"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/www.hongkiat.com\/blog\/wp-json\/wp\/v2\/topic?post=26593"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}