{"id":23013,"date":"2022-11-23T04:01:17","date_gmt":"2022-11-22T22:31:17","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/"},"modified":"2022-11-23T04:01:17","modified_gmt":"2022-11-22T22:31:17","slug":"solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/","title":{"rendered":"[Solved] MySql database structure for : Search based on single column and different value [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-33576428\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"33576428\" data-parentid=\"33575979\" data-score=\"0\" 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>try this:<\/p>\n<pre><code>create table City\n    (\n     Id int,\n     Name varchar(50)\n    );\n\n    insert into City (Id, Name) \n    VALUES \n    (1, 'Toronto'), \n    (2, 'Chicago')\n\n    create table Libraries(\n    Id int,\n    Name varchar(50),\n    CityId int\n    );\n\n    insert into Libraries (Id, Name, CityId) \n    VALUES \n    (1, 'Toronto Library 1', 1),\n    (2, 'Toronto Library 2', 1),\n    (3, 'Chicago Library 1', 2),\n    (4, 'Chicago Library 2', 2)\n\n    create table Books(\n    Id int,\n    Isbn varchar(12),\n    LibraryId int\n    );\n\n    insert into Books (Id, Isbn, LibraryId) \n    Values\n    (1, '1234567891', 1),\n    (2, '13344555', 1),\n    (3, 'x123sada', 1),\n    (4, 'xasdsadas', 2),\n    (5, 'axxzksda', 2)\n\n    select DISTINCT b.Name \n    from Books a\n    inner join Libraries b\n    on a.LibraryId = b.Id\n    where Isbn in ('1234567891', '13344555')\n    and b.CityId = 1\n<\/code><\/pre>\n<p>Edit:<br \/>\nor 4NF:<\/p>\n<pre><code>create table City\n(\n Id int,\n Name varchar(50)\n);\n\ninsert into City (Id, Name) \nVALUES \n(1, 'Toronto'), \n(2, 'Chicago')\n\ncreate table Libraries(\nId int,\nName varchar(50),\nCityId int\n);\n\ninsert into Libraries (Id, Name, CityId) \nVALUES \n(1, 'Toronto Library 1', 1),\n(2, 'Toronto Library 2', 1),\n(3, 'Chicago Library 1', 2),\n(4, 'Chicago Library 2', 2)\n\ncreate table Books(\nId int,\nIsbn varchar(12),\n);\n\ninsert into Books (Id, Isbn) \nValues\n(1, '1234567891'),\n(2, '13344555'),\n(3, 'x123sada'),\n(4, 'xasdsadas'),\n(5, 'axxzksda')\n\ncreate table LibraryBooks\n(\nLibraryId int,\nBookId int\n);\n\ninsert into LibraryBooks (LibraryId, BookId)\nVALUES\n(1, 1),\n(1, 2),\n(3, 1),\n(2, 4),\n(5, 2)\n\nselect DISTINCT c.Name\nfrom Books a\ninner join LibraryBooks b\non a.Id = b.BookId\ninner join Libraries c on\nc.Id = b.LibraryId\nwhere Isbn in ('1234567891', '13344555')\nand c.CityId = 1\n<\/code><\/pre>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">16<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved MySql database structure for : Search based on single column and different value [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] try this: create table City ( Id int, Name varchar(50) ); insert into City (Id, Name) VALUES (1, &#8216;Toronto&#8217;), (2, &#8216;Chicago&#8217;) create table Libraries( Id int, Name varchar(50), CityId int ); insert into Libraries (Id, Name, CityId) VALUES (1, &#8216;Toronto Library 1&#8217;, 1), (2, &#8216;Toronto Library 2&#8217;, 1), (3, &#8216;Chicago Library 1&#8217;, 2), (4, &#8230; <a title=\"[Solved] MySql database structure for : Search based on single column and different value [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\" aria-label=\"More on [Solved] MySql database structure for : Search based on single column and different value [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":[546,340,339,341,500],"class_list":["post-23013","post","type-post","status-publish","format-standard","hentry","category-solved","tag-database","tag-mysql","tag-php","tag-sql","tag-sql-server"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] MySql database structure for : Search based on single column and different value [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-database-structure-for-search-based-on-single-column-and-different-value-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] MySql database structure for : Search based on single column and different value [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] try this: create table City ( Id int, Name varchar(50) ); insert into City (Id, Name) VALUES (1, &#039;Toronto&#039;), (2, &#039;Chicago&#039;) create table Libraries( Id int, Name varchar(50), CityId int ); insert into Libraries (Id, Name, CityId) VALUES (1, &#039;Toronto Library 1&#039;, 1), (2, &#039;Toronto Library 2&#039;, 1), (3, &#039;Chicago Library 1&#039;, 2), (4, ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-22T22:31:17+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-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] MySql database structure for : Search based on single column and different value [closed]\",\"datePublished\":\"2022-11-22T22:31:17+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\"},\"wordCount\":35,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"database\",\"mysql\",\"php\",\"sql\",\"sql-server\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\",\"name\":\"[Solved] MySql database structure for : Search based on single column and different value [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-22T22:31:17+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] MySql database structure for : Search based on single column and different value [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 database structure for : Search based on single column and different value [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-database-structure-for-search-based-on-single-column-and-different-value-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] MySql database structure for : Search based on single column and different value [closed] - JassWeb","og_description":"[ad_1] try this: create table City ( Id int, Name varchar(50) ); insert into City (Id, Name) VALUES (1, 'Toronto'), (2, 'Chicago') create table Libraries( Id int, Name varchar(50), CityId int ); insert into Libraries (Id, Name, CityId) VALUES (1, 'Toronto Library 1', 1), (2, 'Toronto Library 2', 1), (3, 'Chicago Library 1', 2), (4, ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/","og_site_name":"JassWeb","article_published_time":"2022-11-22T22:31:17+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-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] MySql database structure for : Search based on single column and different value [closed]","datePublished":"2022-11-22T22:31:17+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/"},"wordCount":35,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["database","mysql","php","sql","sql-server"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/","name":"[Solved] MySql database structure for : Search based on single column and different value [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-22T22:31:17+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-mysql-database-structure-for-search-based-on-single-column-and-different-value-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] MySql database structure for : Search based on single column and different value [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\/23013","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=23013"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/23013\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=23013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=23013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=23013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}