{"id":6228,"date":"2017-07-09T21:45:01","date_gmt":"2017-07-10T04:45:01","guid":{"rendered":"http:\/\/www.mysqltutorial.org\/?page_id=6228"},"modified":"2023-10-16T18:49:39","modified_gmt":"2023-10-17T01:49:39","slug":"mysql-week","status":"publish","type":"page","link":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-week\/","title":{"rendered":"MySQL WEEK() Function"},"content":{"rendered":"\n<p><strong>Summary<\/strong>: in this tutorial, you will learn how to use the MySQL <code>WEEK()<\/code> function to get the week number for a date.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Introduction to MySQL WEEK() function<\/h2>\n\n\n\n<p>Typically, a year has 365 days for a normal year and 366 days for a leap year. A year is then divided into weeks with each week having exactly 7 days. So for a year we often has 365 \/ 7 = 52 weeks that range from 1 to 52.<\/p>\n\n\n\n<p>The WEEK() function allows you to get the week number of a specific date:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">WEEK(date, mode);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>In this syntax:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><code>date<\/code>: This is the date that you want to get a week number.<\/li>\n\n\n\n<li><code>mode<\/code>: This is an optional argument that determines how the function calculates the week number. It specifies whether the week should start on Monday or Sunday and the returned week number should be between 0 and 52 or 0 and 53.<\/li>\n<\/ul>\n\n\n\n<p>The <code>WEEK()<\/code> function returns a week number based on <a href=\"https:\/\/www.iso.org\/standard\/15903.html\">ISO 8601:1988<\/a>.<\/p>\n\n\n\n<p>If you ignore the <code>mode<\/code> argument, the <code>WEEK()<\/code> function will use the value of the <code>default_week_format<\/code> system variable by default.<\/p>\n\n\n\n<p>To get the current value of <code>default_week_format<\/code> variable, you use the <code>SHOW VARIABLES<\/code> statement as follows:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">SHOW VARIABLES LIKE <span class=\"hljs-string\">'default_week_format'<\/span>;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\">+<span class=\"hljs-comment\">---------------------+-------+<\/span>\n| Variable_name       | Value |\n+<span class=\"hljs-comment\">---------------------+-------+<\/span>\n| default_week_format | 0     |\n+<span class=\"hljs-comment\">---------------------+-------+<\/span>\n1 row in <span class=\"hljs-keyword\">set<\/span> (<span class=\"hljs-number\">0.01<\/span> sec)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>The output shows that the default value of &nbsp;<code>default_week_format<\/code>&nbsp;is 0. <\/p>\n\n\n\n<p>The following table illustrates how the mode argument influences the <code>WEEK<\/code> function:<\/p>\n\n\n\n<figure class=\"wp-block-table ref\"><table><thead><tr><th scope=\"col\">Mode<\/th><th scope=\"col\">First day of week<\/th><th scope=\"col\">Range<\/th><th scope=\"col\">Week 1 is the first week \u2026<\/th><\/tr><\/thead><tbody><tr><td>0<\/td><td>Sunday<\/td><td>0-53<\/td><td>with a Sunday in this year<\/td><\/tr><tr><td>1<\/td><td>Monday<\/td><td>0-53<\/td><td>with 4 or more days this year<\/td><\/tr><tr><td>2<\/td><td>Sunday<\/td><td>1-53<\/td><td>with a Sunday in this year<\/td><\/tr><tr><td>3<\/td><td>Monday<\/td><td>1-53<\/td><td>with 4 or more days this year<\/td><\/tr><tr><td>4<\/td><td>Sunday<\/td><td>0-53<\/td><td>with 4 or more days this year<\/td><\/tr><tr><td>5<\/td><td>Monday<\/td><td>0-53<\/td><td>with a Monday in this year<\/td><\/tr><tr><td>6<\/td><td>Sunday<\/td><td>1-53<\/td><td>with 4 or more days this year<\/td><\/tr><tr><td>7<\/td><td>Monday<\/td><td>1-53<\/td><td>with a Monday in this year<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p>The &#8221; <code>with 4 or more days this year<\/code>&#8221; in the above table means:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If the week contains January 1st and has 4 or more days in the new year, the week is numbered as week 1.<\/li>\n\n\n\n<li>Otherwise, the week is numbered as the last week of the previous year and the next week is week 1.<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\">MySQL WEEK() function example<\/h2>\n\n\n\n<p>Let&#8217;s take some examples of using the <code>WEEK()<\/code> function.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">1) Simple MySQL WEEK() function example<\/h3>\n\n\n\n<p>The following example uses the <code>WEEK()<\/code> function to get the week number of the date <code>'2023-10-16'<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-4\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">SELECT WEEK(<span class=\"hljs-string\">'2023-10-16'<\/span>) <span class=\"hljs-keyword\">as<\/span> week_no;<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-4\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-5\" data-shcb-language-name=\"JavaScript\" data-shcb-language-slug=\"javascript\"><span><code class=\"hljs language-javascript\">+---------+\n| week_no |\n+---------+\n|      <span class=\"hljs-number\">42<\/span> |\n+---------+\n<span class=\"hljs-number\">1<\/span> row <span class=\"hljs-keyword\">in<\/span> <span class=\"hljs-keyword\">set<\/span> (0.01 sec)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-5\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">JavaScript<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">javascript<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h3 class=\"wp-block-heading\">2) Using WEEK() function with table data<\/h3>\n\n\n\n<p>We&#8217;ll use the <code>orders<\/code> table in the <a href=\"https:\/\/www.mysqltutorial.org\/getting-started-with-mysql\/mysql-sample-database\/\">sample database<\/a>:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/orders.svg\" alt=\"\" class=\"wp-image-10769\"\/><\/figure>\n\n\n\n<p>The following statement uses the <code>WEEK()<\/code> function to get the number of orders per week in <code>2003<\/code>:<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-6\" data-shcb-language-name=\"SQL (Structured Query Language)\" data-shcb-language-slug=\"sql\"><span><code class=\"hljs language-sql\"><span class=\"hljs-keyword\">SELECT<\/span> \n  <span class=\"hljs-keyword\">WEEK<\/span>(orderDate) week_no, \n  <span class=\"hljs-keyword\">COUNT<\/span>(*) \n<span class=\"hljs-keyword\">FROM<\/span> \n  orders \n<span class=\"hljs-keyword\">WHERE<\/span> \n  <span class=\"hljs-keyword\">YEAR<\/span>(orderDate) = <span class=\"hljs-number\">2003<\/span> \n<span class=\"hljs-keyword\">GROUP<\/span> <span class=\"hljs-keyword\">BY<\/span> \n  <span class=\"hljs-keyword\">WEEK<\/span>(orderDate);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-6\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">SQL (Structured Query Language)<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">sql<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p>Output:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"147\" height=\"216\" src=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2017\/07\/MySQL-WEEK-Function-example.png\" alt=\"MySQL WEEK Function example\" class=\"wp-image-6229\" title=\"MySQL WEEK Function example\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Summary<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Use the MySQL <code>WEEK()<\/code> function to get the week number from a specific date.<\/li>\n<\/ul>\n<div class=\"helpful-block-content\" data-title=\"\">\n\t<header>\n\t\t<div class=\"wth-question\">Was this tutorial helpful? <\/div>\n\t\t<div class=\"wth-thumbs\">\n\t\t\t<button\n\t\t\t\tdata-post=\"6228\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-week\/\"\n\t\t\t\tdata-post-title=\"MySQL WEEK() Function\"\n\t\t\t\tdata-response=\"1\"\n\t\t\t\tclass=\"wth-btn-rounded wth-yes-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t\tclass=\"feather feather-thumbs-up block w-full h-full\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M14 9V5a3 3 0 0 0-3-3l-4 9v11h11.28a2 2 0 0 0 2-1.7l1.38-9a2 2 0 0 0-2-2.3zM7 22H4a2 2 0 0 1-2-2v-7a2 2 0 0 1 2-2h3\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t<button\n\t\t\t\tdata-response=\"0\"\n\t\t\t\tdata-post=\"6228\"\n\t\t\t\tdata-post-url=\"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/mysql-week\/\"\n\t\t\t\tdata-post-title=\"MySQL WEEK() Function\"\n\t\t\t\tclass=\"wth-btn-rounded wth-no-btn\"\n\t\t\t>\n\t\t\t\t<svg\n\t\t\t\t\txmlns=\"http:\/\/www.w3.org\/2000\/svg\"\n\t\t\t\t\tviewBox=\"0 0 24 24\"\n\t\t\t\t\tfill=\"none\"\n\t\t\t\t\tstroke=\"currentColor\"\n\t\t\t\t\tstroke-width=\"2\"\n\t\t\t\t\tstroke-linecap=\"round\"\n\t\t\t\t\tstroke-linejoin=\"round\"\n\t\t\t\t>\n\t\t\t\t\t<path\n\t\t\t\t\t\td=\"M10 15v4a3 3 0 0 0 3 3l4-9V2H5.72a2 2 0 0 0-2 1.7l-1.38 9a2 2 0 0 0 2 2.3zm7-13h2.67A2.31 2.31 0 0 1 22 4v7a2.31 2.31 0 0 1-2.33 2H17\"\n\t\t\t\t\t><\/path>\n\t\t\t\t<\/svg>\n\t\t\t\t<span class=\"sr-only\"> No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t<div class=\"wth-form hidden\">\n\t\t<div class=\"wth-form-wrapper\">\n\t\t\t<div class=\"wth-title\"><\/div>\n\t\t\t\n\t\t\t<textarea class=\"wth-message\"><\/textarea>\n\n\t\t\t<button class=\"btn btn-primary wth-btn-submit\">Send<\/button>\n\t\t\t<button class=\"btn wth-btn-cancel\">Cancel<\/button>\n\t\t\n\t\t<\/div>\n\t<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>In this tutorial, you will learn how to use the MySQL WEEK function to get the week number for a date and how the WEEK function works in various modes.<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":7032,"menu_order":32,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-6228","page","type-page","status-publish","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MySQL WEEK() Function<\/title>\n<meta name=\"description\" content=\"In this tutorial, you will learn how to use the MySQL WEEK() function to get the week number of a DATE or a DATETIME value.\" \/>\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.mysqltutorial.org\/mysql-week\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL WEEK() Function\" \/>\n<meta property=\"og:description\" content=\"In this tutorial, you will learn how to use the MySQL WEEK() function to get the week number of a DATE or a DATETIME value.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.mysqltutorial.org\/mysql-week\/\" \/>\n<meta property=\"og:site_name\" content=\"MySQL Tutorial\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-17T01:49:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/orders.svg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/\",\"name\":\"MySQL WEEK() Function\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/orders.svg\",\"datePublished\":\"2017-07-10T04:45:01+00:00\",\"dateModified\":\"2023-10-17T01:49:39+00:00\",\"description\":\"In this tutorial, you will learn how to use the MySQL WEEK() function to get the week number of a DATE or a DATETIME value.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/orders.svg\",\"contentUrl\":\"https:\\\/\\\/www.mysqltutorial.org\\\/wp-content\\\/uploads\\\/2023\\\/10\\\/orders.svg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-week\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL Date Functions\",\"item\":\"https:\\\/\\\/www.mysqltutorial.org\\\/mysql-date-functions\\\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MySQL WEEK() Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.mysqltutorial.org\\\/#website\",\"url\":\"https:\\\/\\\/www.mysqltutorial.org\\\/\",\"name\":\"MySQL Tutorial\",\"description\":\"A comprehensive MySQL Tutorial\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.mysqltutorial.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MySQL WEEK() Function","description":"In this tutorial, you will learn how to use the MySQL WEEK() function to get the week number of a DATE or a DATETIME value.","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.mysqltutorial.org\/mysql-week\/","og_locale":"en_US","og_type":"article","og_title":"MySQL WEEK() Function","og_description":"In this tutorial, you will learn how to use the MySQL WEEK() function to get the week number of a DATE or a DATETIME value.","og_url":"https:\/\/www.mysqltutorial.org\/mysql-week\/","og_site_name":"MySQL Tutorial","article_modified_time":"2023-10-17T01:49:39+00:00","og_image":[{"url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/orders.svg","type":"","width":"","height":""}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.mysqltutorial.org\/mysql-week\/","url":"https:\/\/www.mysqltutorial.org\/mysql-week\/","name":"MySQL WEEK() Function","isPartOf":{"@id":"https:\/\/www.mysqltutorial.org\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-week\/#primaryimage"},"image":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-week\/#primaryimage"},"thumbnailUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/orders.svg","datePublished":"2017-07-10T04:45:01+00:00","dateModified":"2023-10-17T01:49:39+00:00","description":"In this tutorial, you will learn how to use the MySQL WEEK() function to get the week number of a DATE or a DATETIME value.","breadcrumb":{"@id":"https:\/\/www.mysqltutorial.org\/mysql-week\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.mysqltutorial.org\/mysql-week\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.mysqltutorial.org\/mysql-week\/#primaryimage","url":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/orders.svg","contentUrl":"https:\/\/www.mysqltutorial.org\/wp-content\/uploads\/2023\/10\/orders.svg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.mysqltutorial.org\/mysql-week\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.mysqltutorial.org\/"},{"@type":"ListItem","position":2,"name":"MySQL Date Functions","item":"https:\/\/www.mysqltutorial.org\/mysql-date-functions\/"},{"@type":"ListItem","position":3,"name":"MySQL WEEK() Function"}]},{"@type":"WebSite","@id":"https:\/\/www.mysqltutorial.org\/#website","url":"https:\/\/www.mysqltutorial.org\/","name":"MySQL Tutorial","description":"A comprehensive MySQL Tutorial","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.mysqltutorial.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6228","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/comments?post=6228"}],"version-history":[{"count":4,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6228\/revisions"}],"predecessor-version":[{"id":11284,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/6228\/revisions\/11284"}],"up":[{"embeddable":true,"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/pages\/7032"}],"wp:attachment":[{"href":"https:\/\/www.mysqltutorial.org\/wp-json\/wp\/v2\/media?parent=6228"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}