{"id":140346,"date":"2025-08-12T08:07:37","date_gmt":"2025-08-12T08:07:37","guid":{"rendered":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/"},"modified":"2025-08-12T08:07:37","modified_gmt":"2025-08-12T08:07:37","slug":"day-6-master-numbers-dates-and-text-ranges","status":"publish","type":"post","link":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/","title":{"rendered":"Day 6 &#8211; Master Numbers, Dates, and Text Ranges"},"content":{"rendered":"<div class=\"youtubomatic-video-container\"><iframe loading=\"lazy\" width=\"580\" height=\"380\" src=\"https:\/\/www.youtube.com\/embed\/oVedm-_F7LI?autoplay=1&#038;controls=1&#038;hl=en\" frameborder=\"0\" allowfullscreen><\/iframe><\/div>\n<p>Ever wanted to filter your SQL results to get just the right range? That\u2019s where BETWEEN shines.<br \/>\nIn this Day 6 lesson of our SQL Made Simple series, you\u2019ll learn:<br \/>\n\u2705 How BETWEEN works with numbers<br \/>\n\u2705 How BETWEEN works with dates<br \/>\n\u2705 The truth about BETWEEN for text \u2014 and the \u201cz trick\u201d to make it work perfectly<\/p>\n<p>We\u2019re working exclusively with the SQLMadeSimpleDB so you can follow along step-by-step.<\/p>\n<p>\ud83c\udfaf Watch, practice, and subscribe to grow your SQL skills.<\/p>\n<p>Join the WhatsApp Community: <a href=\"https:\/\/chat.whatsapp.com\/FBH3HeSpIRGKjZpHG9YJSZ?mode=ems_wa_c\" target=\"_blank\">https:\/\/chat.whatsapp.com\/FBH3HeSpIRGKjZpHG9YJSZ?mode=ems_wa_c<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ever wanted to filter your SQL results to get just the right range? That\u2019s where BETWEEN shines. In this Day 6 lesson of our SQL Made Simple series, you\u2019ll learn: \u2705 How BETWEEN works with numbers \u2705 How BETWEEN works with dates \u2705 The truth about BETWEEN for text \u2014 and the \u201cz trick\u201d to make it work perfectly We\u2019re working exclusively with the SQLMadeSimpleDB so you can follow along&#8230;<\/p>\n","protected":false},"author":1,"featured_media":140347,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":"","tve_updated_post":"","tve_custom_css":"","tve_user_custom_css":"","tve_globals":{},"tcb2_ready":0,"tcb_editor_enabled":0,"tve_landing_page":"","_tve_header":"","_tve_footer":""},"categories":[1],"tags":[],"class_list":["post-140346","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.6 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Day 6 - Master Numbers, Dates, and Text Ranges - UshopWell.com<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Day 6 - Master Numbers, Dates, and Text Ranges - UshopWell.com\" \/>\n<meta property=\"og:description\" content=\"Ever wanted to filter your SQL results to get just the right range? That\u2019s where BETWEEN shines. In this Day 6 lesson of our SQL Made Simple series, you\u2019ll learn: \u2705 How BETWEEN works with numbers \u2705 How BETWEEN works with dates \u2705 The truth about BETWEEN for text \u2014 and the \u201cz trick\u201d to make it work perfectly We\u2019re working exclusively with the SQLMadeSimpleDB so you can follow along...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/\" \/>\n<meta property=\"og:site_name\" content=\"UshopWell.com\" \/>\n<meta property=\"article:published_time\" content=\"2025-08-12T08:07:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2025\/09\/140346\/day-6-master-numbers-dates-and-text-ranges.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"480\" \/>\n\t<meta property=\"og:image:height\" content=\"360\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"UShopWell\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"UShopWell\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/\"},\"author\":{\"name\":\"UShopWell\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\"},\"headline\":\"Day 6 &#8211; Master Numbers, Dates, and Text Ranges\",\"datePublished\":\"2025-08-12T08:07:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/\"},\"wordCount\":101,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/140346\\\/day-6-master-numbers-dates-and-text-ranges.jpg\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/\",\"name\":\"Day 6 - Master Numbers, Dates, and Text Ranges - UshopWell.com\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/140346\\\/day-6-master-numbers-dates-and-text-ranges.jpg\",\"datePublished\":\"2025-08-12T08:07:37+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#primaryimage\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/140346\\\/day-6-master-numbers-dates-and-text-ranges.jpg\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/140346\\\/day-6-master-numbers-dates-and-text-ranges.jpg\",\"width\":480,\"height\":360,\"caption\":\"Day 6 &#8211; Master Numbers, Dates, and Text Ranges\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/day-6-master-numbers-dates-and-text-ranges\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Day 6 &#8211; Master Numbers, Dates, and Text Ranges\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#website\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"name\":\"UshopWell.com\",\"description\":\"The Premiere Online Marketplace\",\"publisher\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#organization\",\"name\":\"UshopWell\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"contentUrl\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/pandaSwea.png\",\"width\":365,\"height\":359,\"caption\":\"UshopWell\"},\"image\":{\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/#\\\/schema\\\/person\\\/6fd1f9e0ff932e534c86c70d5acff0fc\",\"name\":\"UShopWell\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g\",\"caption\":\"UShopWell\"},\"url\":\"https:\\\/\\\/ushopwell.com\\\/ublog\\\/author\\\/kburnettu\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Day 6 - Master Numbers, Dates, and Text Ranges - UshopWell.com","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:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/","og_locale":"en_US","og_type":"article","og_title":"Day 6 - Master Numbers, Dates, and Text Ranges - UshopWell.com","og_description":"Ever wanted to filter your SQL results to get just the right range? That\u2019s where BETWEEN shines. In this Day 6 lesson of our SQL Made Simple series, you\u2019ll learn: \u2705 How BETWEEN works with numbers \u2705 How BETWEEN works with dates \u2705 The truth about BETWEEN for text \u2014 and the \u201cz trick\u201d to make it work perfectly We\u2019re working exclusively with the SQLMadeSimpleDB so you can follow along...","og_url":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/","og_site_name":"UshopWell.com","article_published_time":"2025-08-12T08:07:37+00:00","og_image":[{"width":480,"height":360,"url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2025\/09\/140346\/day-6-master-numbers-dates-and-text-ranges.jpg","type":"image\/jpeg"}],"author":"UShopWell","twitter_card":"summary_large_image","twitter_misc":{"Written by":"UShopWell"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#article","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/"},"author":{"name":"UShopWell","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc"},"headline":"Day 6 &#8211; Master Numbers, Dates, and Text Ranges","datePublished":"2025-08-12T08:07:37+00:00","mainEntityOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/"},"wordCount":101,"commentCount":0,"publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#primaryimage"},"thumbnailUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2025\/09\/140346\/day-6-master-numbers-dates-and-text-ranges.jpg","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/","url":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/","name":"Day 6 - Master Numbers, Dates, and Text Ranges - UshopWell.com","isPartOf":{"@id":"https:\/\/ushopwell.com\/ublog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#primaryimage"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#primaryimage"},"thumbnailUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2025\/09\/140346\/day-6-master-numbers-dates-and-text-ranges.jpg","datePublished":"2025-08-12T08:07:37+00:00","breadcrumb":{"@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#primaryimage","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2025\/09\/140346\/day-6-master-numbers-dates-and-text-ranges.jpg","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2025\/09\/140346\/day-6-master-numbers-dates-and-text-ranges.jpg","width":480,"height":360,"caption":"Day 6 &#8211; Master Numbers, Dates, and Text Ranges"},{"@type":"BreadcrumbList","@id":"https:\/\/ushopwell.com\/ublog\/day-6-master-numbers-dates-and-text-ranges\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/ushopwell.com\/ublog\/"},{"@type":"ListItem","position":2,"name":"Day 6 &#8211; Master Numbers, Dates, and Text Ranges"}]},{"@type":"WebSite","@id":"https:\/\/ushopwell.com\/ublog\/#website","url":"https:\/\/ushopwell.com\/ublog\/","name":"UshopWell.com","description":"The Premiere Online Marketplace","publisher":{"@id":"https:\/\/ushopwell.com\/ublog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ushopwell.com\/ublog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/ushopwell.com\/ublog\/#organization","name":"UshopWell","url":"https:\/\/ushopwell.com\/ublog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/","url":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","contentUrl":"https:\/\/ushopwell.com\/ublog\/wp-content\/uploads\/2018\/01\/pandaSwea.png","width":365,"height":359,"caption":"UshopWell"},"image":{"@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/ushopwell.com\/ublog\/#\/schema\/person\/6fd1f9e0ff932e534c86c70d5acff0fc","name":"UShopWell","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/4adb372cadd43b4d4c57964dab95b0f69618bf960d131c4acf49d96d6bbc9c6e?s=96&d=mm&r=g","caption":"UShopWell"},"url":"https:\/\/ushopwell.com\/ublog\/author\/kburnettu\/"}]}},"_links":{"self":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/140346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/comments?post=140346"}],"version-history":[{"count":0,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/posts\/140346\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media\/140347"}],"wp:attachment":[{"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/media?parent=140346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/categories?post=140346"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ushopwell.com\/ublog\/wp-json\/wp\/v2\/tags?post=140346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}