{"id":25280,"date":"2022-12-09T04:18:35","date_gmt":"2022-12-08T22:48:35","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/"},"modified":"2022-12-09T04:18:35","modified_gmt":"2022-12-08T22:48:35","slug":"solved-filter-table-column-and-view-the-data-in-the-another-column-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/","title":{"rendered":"[Solved] filter table column and view the data in the another column [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n
\n

I can’t explain this<\/strong><\/p>\n<\/blockquote>\n

Let me explain it for you.<\/p>\n

You are looking for pivoting<\/em> the comments<\/code> values for the concern<\/code> for each student. Unfortunately, MySQL has no pivot table operator. <\/p>\n

However, you can use the CASE<\/code> expression to do this. Like so:<\/p>\n

SELECT \n  student_name,\n  MAX(CASE WHEN concern = 'Academics'   THEN comments END) AS 'Accademics',\n  MAX(CASE WHEN concern = 'Accomodation' THEN comments END) AS 'Accomodation'\nFROM acad_concern    \nGROUP BY student_name;\n<\/code><\/pre>\n
SQL Fiddle Demo<\/a><\/h2>\n
This will give you:<\/p>\n
|  STUDENT_NAME |  ACCADEMICS | ACCOMODATION |\n----------------------------------------------\n|   Anne Curtis | this acad.. |  this is aco |\n| benedict grey | also acad.. |  also accomo |\n<\/code><\/pre>\n
For multiple concern<\/code>s and you don’t need to write them manually, you have to do this dynamically using dynamic SQL like this:<\/p>\n
SET @sql = NULL;\nSELECT\n  GROUP_CONCAT(DISTINCT CONCAT('MAX(IF(concern = ''',\n      concern, ''', comments, NULL)) AS ', '''', concern , '''')\n  ) INTO @sql\nFROM acad_concern;\n\nSET @sql = CONCAT('SELECT student_name, ', @sql , '\n    FROM acad_concern    \n    GROUP BY student_name;');\n\nprepare stmt \nFROM @sql;\n\nexecute stmt;\n<\/code><\/pre>\n
Updated SQL Fiddle Demo<\/a><\/h2>\n<\/p><\/div>\n
<\/div>\n<\/div>\n
            6<\/span> <\/p><\/div>\n<\/div>\n
[ad_2]<\/p>\n
solved filter table column and view the data in the another column [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
[ad_1] I can’t explain this Let me explain it for you. You are looking for pivoting the comments values for the concern for each student. Unfortunately, MySQL has no pivot table operator. However, you can use the CASE expression to do this. Like so: SELECT student_name, MAX(CASE WHEN concern = ‘Academics’ THEN comments END) AS … 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,339,839,341],"class_list":["post-25280","post","type-post","status-publish","format-standard","hentry","category-solved","tag-mysql","tag-php","tag-pivot","tag-sql"],"yoast_head":"\n[Solved] filter table column and view the data in the another column [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-filter-table-column-and-view-the-data-in-the-another-column-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] filter table column and view the data in the another column [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] I can’t explain this Let me explain it for you. You are looking for pivoting the comments values for the concern for each student. Unfortunately, MySQL has no pivot table operator. However, you can use the CASE expression to do this. Like so: SELECT student_name, MAX(CASE WHEN concern = 'Academics' THEN comments END) AS ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-12-08T22:48:35+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\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] filter table column and view the data in the another column [closed]\",\"datePublished\":\"2022-12-08T22:48:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/\"},\"wordCount\":103,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"mysql\",\"php\",\"pivot\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/\",\"name\":\"[Solved] filter table column and view the data in the another column [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-12-08T22:48:35+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] filter table column and view the data in the another column [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=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] filter table column and view the data in the another column [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-filter-table-column-and-view-the-data-in-the-another-column-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] filter table column and view the data in the another column [closed] - JassWeb","og_description":"[ad_1] I can’t explain this Let me explain it for you. You are looking for pivoting the comments values for the concern for each student. Unfortunately, MySQL has no pivot table operator. However, you can use the CASE expression to do this. Like so: SELECT student_name, MAX(CASE WHEN concern = 'Academics' THEN comments END) AS ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/","og_site_name":"JassWeb","article_published_time":"2022-12-08T22:48:35+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] filter table column and view the data in the another column [closed]","datePublished":"2022-12-08T22:48:35+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/"},"wordCount":103,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["mysql","php","pivot","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/","name":"[Solved] filter table column and view the data in the another column [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-12-08T22:48:35+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-filter-table-column-and-view-the-data-in-the-another-column-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] filter table column and view the data in the another column [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=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","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\/25280","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=25280"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/25280\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=25280"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=25280"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=25280"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}