{"id":8046,"date":"2022-06-23T07:25:00","date_gmt":"2022-06-23T05:25:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=8046"},"modified":"2022-10-06T13:26:32","modified_gmt":"2022-10-06T11:26:32","slug":"requete-sql-server-substring","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/","title":{"rendered":"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring"},"content":{"rendered":"\n

Exemples de scripts pour d\u00e9couper une cha\u00eene de caract\u00e8res avec la fonction SQL Server SUBSTRING.<\/em><\/strong><\/h4>\n\n\n\n

Cette fonction texte fournie par le SGBD<\/a> permet essentiellement de d\u00e9couper des textes et de s\u00e9lectionner seulement une partie d’une chaine de caract\u00e8res. Tout d’abord, la fonction texte SUBSTRING est \u00e9quivalente \u00e0 la fonction SUBSTR dans les langages SQL non Microsoft, comme Oracle<\/a> ou MySQL<\/a> qui utilise les deux, SUBTR et SUBSTRING. Elle permet de d\u00e9couper une chaine de caract\u00e8res. <\/p>\n\n\n\n

Exemples de requ\u00eates SQL Server SUBSTRING<\/h2>\n\n\n\n

La fonction utilise 3 arguments obligatoires qui sont les suivants: <\/p>\n\n\n\n

  1. L’expression<\/em> : Le champs texte \u00e0 d\u00e9couper, les types support\u00e9s sont les suivants: caract\u00e8res, binaire, text, ntext ou le type image. L’expression \u00e0 d\u00e9couper peut bien s\u00fbr \u00eatre contenu dans une variable T-SQL.<\/li>
  2. Le caract\u00e8re de d\u00e9but<\/em> : c’est \u00e0 dire \u00e0 partir de quel caract\u00e8re doit commencer le d\u00e9coupage<\/li>
  3. La longueur<\/em> : c’est le nombre de caract\u00e8res que la fonction<\/a> SUBSTRING retourne, soit la longueur maximale du texte \u00e0 d\u00e9coup\u00e9 <\/li><\/ol>\n\n\n\n

    Si un des arguments est manquant, le syst\u00e8me renvoie cette erreur: La fonction substring requiert 3 argument(s)<\/em>., sur une version Francaise de SQL Server. Ou encore ce message d’erreur : The substring function requires 3 argument(s)<\/em>. sur une version SQL Server en Anglais. <\/p>\n\n\n\n

    1. D\u00e9couper une chaine de caract\u00e8re statique avec la fonction SQL Server Substring<\/h3>\n\n\n\n

    Cette requ\u00eate renvoie les trois premi\u00e8res lettres de la chaine ABCDEFGH qui en contient huit.<\/p>\n\n\n\n

    SELECT SUBSTRING('ABCDEFGH', 1, 3) AS R\u00e9sultat;\n\n-- R\u00e9sultat\nABC<\/pre>\n\n\n\n
    Cet autre exemple montre comment utiliser le deuxi\u00e8me argument (c’est \u00e0 dire le caract\u00e8re de d\u00e9but), cette fois avec une valeur n\u00e9gative. Le SGBD utilise le plus grand des nombres entre d\u00e9but + longueur -1 et 0. Soit dans notre exemple : <\/p>\n\n\n\n
    0+3-1 = 2<\/p>\n\n\n\n
    Donc seules les deux premi\u00e8res lettres de l’alphabet sont affich\u00e9es. <\/p>\n\n\n\n
    SELECT SUBSTRING('ABCDEFGH', 0, 3) AS R\u00e9sultat;\n\n-- R\u00e9sultat\nAB<\/pre>\n\n\n\n
    2. Imbriquer la fonction avec d’autres fonctions natives SQL Server<\/h3>\n\n\n\n
    Il est bien s\u00fbr possible de r\u00e9utiliser le r\u00e9sultat directement dans une fonction texte. Par exemple avec le nom du moins SQL Server<\/a>. La premi\u00e8re partie de la requ\u00eate affiche donc le nom du mois en cours en toutes lettres : Juillet<\/strong><\/p>\n\n\n\n
    Par contre la deuxi\u00e8me partie retourne uniquement les 4 premi\u00e8res lettres du Mois : Juil<\/strong><\/p>\n\n\n\n
    SELECT DATENAME(MONTH, GETDATE());\n\n-- R\u00e9sultat\nJuillet\n\nSELECT SUBSTRING(DATENAME(MONTH, GETDATE()), 1, 4) AS R\u00e9sultat;\n\n-- R\u00e9sultat\nJuil<\/pre>\n\n\n\n
    3. Utiliser la fonction SUBSTRING avec des variables T-SQL<\/h3>\n\n\n\n
    Enfin, pour encore plus de lisibilit\u00e9, de modularit\u00e9 et de r\u00e9utilisabilit\u00e9, utiliser des variables dans le code. Voici donc un exemple qui renvoie une variable avec le nom du jour en toutes lettres<\/a>, en majuscules et qui retourne seulement les 3 premi\u00e8res lettres du jour de la semaine en texte.<\/p>\n\n\n\n
    DECLARE @Jour as NVARCHAR(20);\nSELECT  @Jour = DATENAME(WEEKDAY, GETDATE());\nSELECT  UPPER(@Jour); \n\n-- R\u00e9sultat : jour en toutes lettres\nJEUDI\n\nSELECT UPPER(SUBSTRING(@Jour, 1, 3));\n\n-- R\u00e9sultat : les trois premi\u00e8res lettres du jour de semaine\nJEU<\/pre>\n\n\n\n
    Les fonctions textes comme les fonctions temps sont au centre du d\u00e9veloppement et donc des tutoriels SQL Server. Elles permettent de manipuler les donn\u00e9es et d’afficher diff\u00e9rentes parties des dates sous diff\u00e9rents formats. <\/p>\n\n\n\n
    \nhttps:\/\/expert-only.com\/transact-sql\/afficher-le-mois-en-lettres-avec-sql-server\/\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"
    Exemples de scripts pour d\u00e9couper une cha\u00eene de caract\u00e8res avec la fonction SQL Server SUBSTRING. Cette fonction texte fournie par le SGBD permet essentiellement de d\u00e9couper des textes et de s\u00e9lectionner seulement une partie d’une chaine de caract\u00e8res. Tout …<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10942,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-8046","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"yoast_head":"\nD\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring<\/title>\n<meta name=\"description\" content=\"Exemples de scripts pratiques pour utiliser la fonction texte SUBSTRING pour d\u00e9couper une chaine de caract\u00e8res avec une requ\u00eate SQL Server.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring\" \/>\n<meta property=\"og:description\" content=\"Exemples de scripts pratiques pour utiliser la fonction texte SUBSTRING pour d\u00e9couper une chaine de caract\u00e8res avec une requ\u00eate SQL Server.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-23T05:25:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-06T11:26:32+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\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:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring\",\"datePublished\":\"2022-06-23T05:25:00+00:00\",\"dateModified\":\"2022-10-06T11:26:32+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\"},\"wordCount\":496,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\",\"name\":\"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"datePublished\":\"2022-06-23T05:25:00+00:00\",\"dateModified\":\"2022-10-06T11:26:32+00:00\",\"description\":\"Exemples de scripts pratiques pour utiliser la fonction texte SUBSTRING pour d\u00e9couper une chaine de caract\u00e8res avec une requ\u00eate SQL Server.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring","description":"Exemples de scripts pratiques pour utiliser la fonction texte SUBSTRING pour d\u00e9couper une chaine de caract\u00e8res avec une requ\u00eate SQL Server.","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:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/","og_locale":"fr_FR","og_type":"article","og_title":"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring","og_description":"Exemples de scripts pratiques pour utiliser la fonction texte SUBSTRING pour d\u00e9couper une chaine de caract\u00e8res avec une requ\u00eate SQL Server.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-06-23T05:25:00+00:00","article_modified_time":"2022-10-06T11:26:32+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring","datePublished":"2022-06-23T05:25:00+00:00","dateModified":"2022-10-06T11:26:32+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/"},"wordCount":496,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/","name":"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","datePublished":"2022-06-23T05:25:00+00:00","dateModified":"2022-10-06T11:26:32+00:00","description":"Exemples de scripts pratiques pour utiliser la fonction texte SUBSTRING pour d\u00e9couper une chaine de caract\u00e8res avec une requ\u00eate SQL Server.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/work-DE8FCB57747_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/requete-sql-server-substring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"D\u00e9couper une cha\u00eene de caract\u00e8res Sql Server avec Substring"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/8046","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=8046"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/8046\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10942"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=8046"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=8046"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=8046"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}