{"id":32185,"date":"2023-01-27T07:39:38","date_gmt":"2023-01-27T02:09:38","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/"},"modified":"2023-01-27T07:39:38","modified_gmt":"2023-01-27T02:09:38","slug":"solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/","title":{"rendered":"[Solved] MySQL-How to select column based on value in a different column but same row? [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-52123247\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"52123247\" data-parentid=\"52122560\" data-score=\"2\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>This is one of the simplest types of SQL queries.<\/p>\n<pre><code>SELECT user_id\nFROM yourTable\nWHERE user_name=\"UserA\"\n<\/code><\/pre>\n<p>The first line says which columns you want to return in the result.<\/p>\n<p>The second line identifies the table you want to get the columns from.<\/p>\n<p>The third line specifies conditions on the rows you want to use from the table.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved MySQL-How to select column based on value in a different column but same row? [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] This is one of the simplest types of SQL queries. SELECT user_id FROM yourTable WHERE user_name=&#8221;UserA&#8221; The first line says which columns you want to return in the result. The second line identifies the table you want to get the columns from. The third line specifies conditions on the rows you want to use &#8230; <a title=\"[Solved] MySQL-How to select column based on value in a different column but same row? [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\" aria-label=\"More on [Solved] MySQL-How to select column based on value in a different column but same row? [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[340,953],"class_list":["post-32185","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-select"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] MySQL-How to select column based on value in a different column but same row? [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] MySQL-How to select column based on value in a different column but same row? [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] This is one of the simplest types of SQL queries. SELECT user_id FROM yourTable WHERE user_name=&quot;UserA&quot; The first line says which columns you want to return in the result. The second line identifies the table you want to get the columns from. The third line specifies conditions on the rows you want to use ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2023-01-27T02:09:38+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] MySQL-How to select column based on value in a different column but same row? [closed]\",\"datePublished\":\"2023-01-27T02:09:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\"},\"wordCount\":85,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"select\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\",\"name\":\"[Solved] MySQL-How to select column based on value in a different column but same row? [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2023-01-27T02:09:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] MySQL-How to select column based on value in a different column but same row? [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] MySQL-How to select column based on value in a different column but same row? [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] MySQL-How to select column based on value in a different column but same row? [closed] - JassWeb","og_description":"[ad_1] This is one of the simplest types of SQL queries. SELECT user_id FROM yourTable WHERE user_name=\"UserA\" The first line says which columns you want to return in the result. The second line identifies the table you want to get the columns from. The third line specifies conditions on the rows you want to use ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/","og_site_name":"JassWeb","article_published_time":"2023-01-27T02:09:38+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] MySQL-How to select column based on value in a different column but same row? [closed]","datePublished":"2023-01-27T02:09:38+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/"},"wordCount":85,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","select"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/","name":"[Solved] MySQL-How to select column based on value in a different column but same row? [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2023-01-27T02:09:38+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-how-to-select-column-based-on-value-in-a-different-column-but-same-row-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] MySQL-How to select column based on value in a different column but same row? [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1776403586","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/32185","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=32185"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/32185\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=32185"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=32185"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=32185"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}