{"id":20859,"date":"2020-08-05T23:53:05","date_gmt":"2020-08-06T06:53:05","guid":{"rendered":"https:\/\/careerkarma.com\/blog\/?p=20859"},"modified":"2021-01-04T05:49:11","modified_gmt":"2021-01-04T13:49:11","slug":"sql-concatenate","status":"publish","type":"post","link":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/","title":{"rendered":"How to Build a Query Using the SQL Concatenate Function"},"content":{"rendered":"\n<p>When working with queries, sometimes we need to take raw data from our database and reformat it in a different way for use elsewhere. In this article, we look at a couple of functions in MySQL to help us work with string types in our queries.&nbsp;<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Building the Schema<\/h2>\n\n\n\n<p>This section is devoted to preparing a quick schema to illustrate the SQL concepts covered in this post. We use MySQL for the functions \u2013 I recommend using <a href=\"http:\/\/sqlfiddle.com\/#!9\/2607e0\/8\/0\" target=\"_blank\" rel=\"noopener\" rel=\"nofollow\">SQL Fiddle<\/a> to practice using syntax and running your search queries. There, you can also test your queries in other relational databases.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create Table and Insert Values<\/h3>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>CREATE TABLE birthdays (\n name varchar(200) NOT NULL,\n birthday varchar(10) NOT NULL\n);\n \nINSERT INTO birthdays (name, birthday) VALUES(&quot;Jane&quot;, &quot;11\/20\/1993&quot;);\nINSERT INTO birthdays (name, birthday) VALUES(&quot;Duncan&quot;, &quot;01\/15\/1987&quot;);\nINSERT INTO birthdays (name, birthday) VALUES(&quot;Lucas&quot;, &quot;07\/21\/1996&quot;);\nINSERT INTO birthdays (name, birthday) VALUES(&quot;Alexa&quot;, &quot;12\/31\/1988&quot;);<\/pre><\/div>\n\n\n\n<p>The top four lines create the table \u201cbirthdays\u201d<em> <\/em>with the columns \u201cname\u201d and \u201cbirthday\u201d. The rest inserts values into the database. We use this when we build our query statements.&nbsp;<br><\/p>\n\n\n\n<p>If we run a basic query on our table, this is what the query statement and the results would look like:<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT name, birthday FROM birthdays;<\/pre><\/div>\n\n\n\n<p><strong>Results:<\/strong><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>name<\/strong><\/td><td><strong>birthday<\/strong><\/td><\/tr><tr><td>Chris<\/td><td>11\/20\/1993<\/td><\/tr><tr><td>Duncan<\/td><td>01\/15\/1987<\/td><\/tr><tr><td>Lucas<\/td><td>07\/21\/1996<\/td><\/tr><tr><td>Alexa<\/td><td>12\/31\/1988<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Building the Query Statements<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">CONCAT()<\/h3>\n\n\n\n<p>The <code>CONCAT()<\/code> function returns the result after joining the arguments into one string. There is at least one argument, but there may be multiple functions. Arguments in the function could be any one of the following:<br><\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Binary String<\/strong> \u2013 If any one of the arguments is a binary string, the return value is a binary string.&nbsp;<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Nonbinary String <\/strong>\u2013 A typical string value. If all arguments are nonbinary string values, <code>CONCAT()<\/code> returns a nonbinary string value.<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Numeric<\/strong> \u2013 If one input is of a numeric type, it is coerced to a nonbinary string before it\u2019s joined with the other arguments.&nbsp;<\/li><\/ul>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Null<\/strong> \u2013 If there are NULL values, those values are simply ignored.&nbsp;<\/li><\/ul>\n\n\n\n<p>The formal syntax is as follows:&nbsp;<\/p>\n\n\n\n<p><code>CONCAT( &lt;str value 1&gt;, &lt;str value 2&gt;, [ \u2026 &lt;str value N&gt; ]);<\/code><\/p>\n\n\n\n<p>We use the CONCAT keyword with a pair of parentheses to indicate it\u2019s a function. Inside the parentheses is N input strings. Here\u2019s a it looks using MySQL:&nbsp;<\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT CONCAT(name, &quot; &quot;, birthday) AS Result\nFROM birthdays;<\/pre><\/div>\n\n\n\n<p>We \u201cSELECT\u201d the return value from the concatenation of name, a space char, and birthday and assign it the name \u201cResult\u201d.&nbsp;<br><\/p>\n\n\n\n<p>The result of this query is:&nbsp;<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>Result&nbsp;&nbsp;<\/strong><\/td><\/tr><tr><td>Chris 11\/20\/1993<\/td><\/tr><tr><td>Duncan 01\/15\/1987<\/td><\/tr><tr><td>Lucas 07\/21\/1996<\/td><\/tr><tr><td>Alexa 12\/31\/1988<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p><\/p>\n\n\n\n<p>Compare this result to the original query statement we tested with in the Building the Schema section. How does it differ? What would be an advantage to setting data this way as opposed to the given way?&nbsp;<br><\/p>\n\n\n\n<p>There\u2019s necessarily no right or wrong answer. It\u2019s all about how you rely on this data in your application.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">CONCAT_WS()<\/h3>\n\n\n\n<p>The <code>CONCAT_WS()<\/code> function is the same as the <code>CONCAT()<\/code> function, however, there is a required first argument that\u2019s not in the original <code>CONCAT()<\/code> function. This argument is the separator that goes in between each of the rest of the arguments in the function. The rest of the rules of <code>CONCAT()<\/code> apply.<br><\/p>\n\n\n\n<p>The formal syntax is as follows:&nbsp;<\/p>\n\n\n\n<p><code>CONCAT_WS(&lt;separator&gt;, &lt;str value 1&gt;, &lt;str value 2&gt;, [ \u2026 &lt;str value N&gt; ]);<\/code><\/p>\n\n\n\n<p>We use the <code>CONCAT_WS()<\/code> keyword with a pair of parentheses to indicate it\u2019s a function. The first argument inside the parentheses is the separator that goes between each input string. The rest of the arguments are strings we join together. Here\u2019s a look using MySQL:&nbsp;<br><\/p>\n\n\n\n<div class=\"wp-block-codemirror-blocks-code-block code-block\"><pre>SELECT CONCAT_WS(&quot;, &quot;, name, birthday) AS Result\nFROM birthdays;<\/pre><\/div>\n\n\n\n<p>The result is string concatenation with the first argument in between each of the other arguments.<br><\/p>\n\n\n\n<table class=\"wp-block-table course-info-table\"><tbody><tr><td><strong>Result&nbsp;&nbsp;<\/strong><\/td><\/tr><tr><td>Chris, 11\/20\/1993<\/td><\/tr><tr><td>Duncan 01\/15\/1987<\/td><\/tr><tr><td>Lucas 07\/21\/1996<\/td><\/tr><tr><td>Alexa 12\/31\/1988<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p><\/p>\n\n\n\n<p>Like the <code>CONCAT()<\/code> function, the <code>CONCAT_WS()<\/code> function returns only one column, named Result, where the value is the input string(s) concatenated with the separator character.&nbsp;<br><\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<p>In this article, we cover the <code>SQL CONCAT()<\/code> and <code>CONCAT_WS()<\/code> functions as they relate to its use in MySQL. Be aware there might be minor differences in syntax when using other relational databases as they might have their own flavor of SQL. The concept of the function is the same, but it might be differently worded.<\/p>\n","protected":false},"excerpt":{"rendered":"When working with queries, sometimes we need to take raw data from our database and reformat it in a different way for use elsewhere. In this article, we look at a couple of functions in MySQL to help us work with string types in our queries.&nbsp; Building the Schema This section is devoted to preparing&hellip;","protected":false},"author":77,"featured_media":20860,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[17284],"tags":[],"class_list":{"0":"post-20859","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-sql"},"acf":{"post_sub_title":"","sprint_id":"","query_class":"SQL","school_sft":"","parent_sft":"","school_privacy_policy":"","has_review":null,"is_sponser_post":"","is_guest_post":""},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v27.0 (Yoast SEO v27.0) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>How to Build a Query Using the SQL Concatenate Function | Career Karma<\/title>\n<meta name=\"description\" content=\"As engineers, we use the SQL CONCAT() function to join two strings together and then use the result to query a database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Build a Query Using the SQL Concatenate Function\" \/>\n<meta property=\"og:description\" content=\"As engineers, we use the SQL CONCAT() function to join two strings together and then use the result to query a database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\" \/>\n<meta property=\"og:site_name\" content=\"Career Karma\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/facebook.com\/careerkarmaapp\" \/>\n<meta property=\"article:published_time\" content=\"2020-08-06T06:53:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-01-04T13:49:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1020\" \/>\n\t<meta property=\"og:image:height\" content=\"765\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Christina Kopecky\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@career_karma\" \/>\n<meta name=\"twitter:site\" content=\"@career_karma\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Christina Kopecky\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\"},\"author\":{\"name\":\"Christina Kopecky\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e\"},\"headline\":\"How to Build a Query Using the SQL Concatenate Function\",\"datePublished\":\"2020-08-06T06:53:05+00:00\",\"dateModified\":\"2021-01-04T13:49:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\"},\"wordCount\":627,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg\",\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\",\"name\":\"How to Build a Query Using the SQL Concatenate Function | Career Karma\",\"isPartOf\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg\",\"datePublished\":\"2020-08-06T06:53:05+00:00\",\"dateModified\":\"2021-01-04T13:49:11+00:00\",\"author\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e\"},\"description\":\"As engineers, we use the SQL CONCAT() function to join two strings together and then use the result to query a database.\",\"breadcrumb\":{\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg\",\"width\":1020,\"height\":765,\"caption\":\"Four people gathered around a white MacBook Pro\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Blog\",\"item\":\"https:\/\/careerkarma.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL\",\"item\":\"https:\/\/careerkarma.com\/blog\/sql\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"How to Build a Query Using the SQL Concatenate Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#website\",\"url\":\"https:\/\/careerkarma.com\/blog\/\",\"name\":\"Career Karma\",\"description\":\"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/careerkarma.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e\",\"name\":\"Christina Kopecky\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg\",\"contentUrl\":\"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg\",\"caption\":\"Christina Kopecky\"},\"description\":\"Christina is an experienced technical writer, covering topics as diverse as Java, SQL, Python, and web development. She earned her Master of Music in flute performance from the University of Kansas and a bachelor's degree in music with minors in French and mass communication from Southeast Missouri State. Prior to joining the Career Karma team in June 2020, Christina was a teaching assistant, team lead, and section lead at Lambda School, where she led student groups, performed code and project reviews, and debugged problems for students. Christina's technical content is featured frequently in publications like Codecademy, Repl.it, and Educative.\",\"sameAs\":[\"http:\/\/www.linkedin.com\/in\/cmvnk\"],\"url\":\"https:\/\/careerkarma.com\/blog\/author\/christina-kopecky\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to Build a Query Using the SQL Concatenate Function | Career Karma","description":"As engineers, we use the SQL CONCAT() function to join two strings together and then use the result to query a database.","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:\/\/careerkarma.com\/blog\/sql-concatenate\/","og_locale":"en_US","og_type":"article","og_title":"How to Build a Query Using the SQL Concatenate Function","og_description":"As engineers, we use the SQL CONCAT() function to join two strings together and then use the result to query a database.","og_url":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/","og_site_name":"Career Karma","article_publisher":"http:\/\/facebook.com\/careerkarmaapp","article_published_time":"2020-08-06T06:53:05+00:00","article_modified_time":"2021-01-04T13:49:11+00:00","og_image":[{"width":1020,"height":765,"url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg","type":"image\/jpeg"}],"author":"Christina Kopecky","twitter_card":"summary_large_image","twitter_creator":"@career_karma","twitter_site":"@career_karma","twitter_misc":{"Written by":"Christina Kopecky","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#article","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/"},"author":{"name":"Christina Kopecky","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e"},"headline":"How to Build a Query Using the SQL Concatenate Function","datePublished":"2020-08-06T06:53:05+00:00","dateModified":"2021-01-04T13:49:11+00:00","mainEntityOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/"},"wordCount":627,"commentCount":0,"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg","articleSection":["SQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/careerkarma.com\/blog\/sql-concatenate\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/","url":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/","name":"How to Build a Query Using the SQL Concatenate Function | Career Karma","isPartOf":{"@id":"https:\/\/careerkarma.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage"},"image":{"@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage"},"thumbnailUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg","datePublished":"2020-08-06T06:53:05+00:00","dateModified":"2021-01-04T13:49:11+00:00","author":{"@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e"},"description":"As engineers, we use the SQL CONCAT() function to join two strings together and then use the result to query a database.","breadcrumb":{"@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/careerkarma.com\/blog\/sql-concatenate\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#primaryimage","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/08\/mimi-thian-vdXMSiX-n6M-unsplash.jpg","width":1020,"height":765,"caption":"Four people gathered around a white MacBook Pro"},{"@type":"BreadcrumbList","@id":"https:\/\/careerkarma.com\/blog\/sql-concatenate\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Blog","item":"https:\/\/careerkarma.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL","item":"https:\/\/careerkarma.com\/blog\/sql\/"},{"@type":"ListItem","position":3,"name":"How to Build a Query Using the SQL Concatenate Function"}]},{"@type":"WebSite","@id":"https:\/\/careerkarma.com\/blog\/#website","url":"https:\/\/careerkarma.com\/blog\/","name":"Career Karma","description":"Latest Coding Bootcamp News &amp; Career Hacks from Industry Insiders","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/careerkarma.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/ae0cdc4a5d198690d78482646894074e","name":"Christina Kopecky","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/careerkarma.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg","contentUrl":"https:\/\/careerkarma.com\/blog\/wp-content\/uploads\/2020\/06\/image-3-150x150.jpg","caption":"Christina Kopecky"},"description":"Christina is an experienced technical writer, covering topics as diverse as Java, SQL, Python, and web development. She earned her Master of Music in flute performance from the University of Kansas and a bachelor's degree in music with minors in French and mass communication from Southeast Missouri State. Prior to joining the Career Karma team in June 2020, Christina was a teaching assistant, team lead, and section lead at Lambda School, where she led student groups, performed code and project reviews, and debugged problems for students. Christina's technical content is featured frequently in publications like Codecademy, Repl.it, and Educative.","sameAs":["http:\/\/www.linkedin.com\/in\/cmvnk"],"url":"https:\/\/careerkarma.com\/blog\/author\/christina-kopecky\/"}]}},"_links":{"self":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20859","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/comments?post=20859"}],"version-history":[{"count":0,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/posts\/20859\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media\/20860"}],"wp:attachment":[{"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/media?parent=20859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/categories?post=20859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/careerkarma.com\/blog\/wp-json\/wp\/v2\/tags?post=20859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}