{"id":3552,"date":"2022-08-11T13:10:20","date_gmt":"2022-08-11T13:10:20","guid":{"rendered":"http:\/\/kevinbk.com\/?p=3552"},"modified":"2022-08-11T14:49:28","modified_gmt":"2022-08-11T14:49:28","slug":"filtrar-por-colunas-identicas-em-bancos-de-dado-com-sql-query","status":"publish","type":"post","link":"https:\/\/kevinbk.com\/ko\/\uac19\uc740-\uc5f4\ub85c-\ud544\ud130\ub9c1\ud558\uae30-sql-\ucffc\ub9ac\uc5d0\uc11c-\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c\/","title":{"rendered":"SQL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\uc11c \ub3d9\uc77c\ud55c \uc5f4\uc744 \ud544\ud130\ub9c1\ud569\ub2c8\ub2e4."},"content":{"rendered":"<p>SQL, MySQL \ub610\ub294 MariaDB \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc758 \uc5f4\uc744 \uae30\uc900\uc73c\ub85c \ud589\uc744 \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ucc3e\uace0 \uc788\ub098\uc694? \uc2e4\ud589\ud560 \ucffc\ub9ac\ub97c \ucc3e\uace0 \uacc4\uc2e0\uac00\uc694? <\/p>\n\n\n\n<p>\ucd5c\uadfc\uc5d0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0\uc11c \ub450 \uc5f4\uc758 \uac12\uc774 \ub3d9\uc77c\ud55c \ud589\ub9cc \ud544\ud130\ub9c1\ud558\uc5ec \ud45c\uc2dc\ud574\uc57c \ud558\ub294 \uc0c1\ud669\uc774 \uc788\uc5c8\uc2b5\ub2c8\ub2e4. \uba87 \uc2dc\uac04 \ub3d9\uc548 \uac80\uc0c9\ud55c \ud6c4 \uac04\ub2e8\ud55c \ud574\uacb0\ucc45\uc744 \ucc3e\uc544\uc11c \uc5ec\uae30\uc5d0 \uacf5\uc720\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub098\ub294 \ud504\ub85c\uadf8\ub798\uba38\uac00 \uc544\ub2c8\uba70, \uc774\ub7f0 \ud301\uc744 \ucc3e\ub294 \ub300\ubd80\ubd84\uc758 \uc0ac\ub78c\ub4e4\ub3c4 \ucf54\ub4dc\uc5d0 \ub300\ud574 \ub9ce\uc740 \uc774\ud574\uac00 \uc5c6\ub2e4\uace0 \uc0dd\uac01\ud569\ub2c8\ub2e4. <\/p>\n\n\n\n<p>Navicat \ud504\ub85c\uadf8\ub7a8\uc744 \uc0ac\uc6a9\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \ud3b8\uc9d1\ud558\ub294 \uac83\uc774 \uc77c\ubc18\uc801\uc774\uba70, \uc774 \ud504\ub85c\uadf8\ub7a8\uc740 Microsoft Excel\uc774\ub098 Apple Numbers\uc640 \uac19\uc774 \ud589\uacfc \uc5f4\uc744 \uc790\uc720\ub86d\uac8c \ud3b8\uc9d1\ud560 \uc218 \uc788\uc744 \ubfd0 \uc544\ub2c8\ub77c \ub9e4\uc6b0 \ube60\ub974\uace0 \uc2e4\uc6a9\uc801\uc785\ub2c8\ub2e4.<\/p>\n\n\n\n<p>\ub300\ubd80\ubd84\uc758 \uc0ac\ub78c\ub4e4\uc740 \uc6f9 \uc0ac\uc774\ud2b8\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uad00\ub9ac\ud558\uae30 \uc704\ud574 PhpmyAdmin\uc744 \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \ub450 \uac00\uc9c0 \ubaa8\ub450 SQL \ub610\ub294 \ucffc\ub9ac \ud0ed\uc744 \ud1b5\ud574 \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">SQL \ucffc\ub9ac\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud544\ud130\ub9c1\ud558\uae30<\/h2>\n\n\n\n<p>\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc804\ubb38\uac00\ub294 \uc544\ub2c8\uae30 \ub54c\ubb38\uc5d0 \ucffc\ub9ac \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc5ec \ud544\ud130\ub9c1\ub41c \ud14c\uc774\ube14\uc744 \ud45c\uc2dc\ud560 \uc218 \uc788\ub2e4\ub294 \uac83\uc744 \ubab0\ub790\uc5c8\uc9c0\ub9cc \ub2e4\ud589\ud788 \ubc1c\uacac\ud558\uac8c \ub418\uc5c8\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub0b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0ac\uc6a9\uc740 \ud589\uc744 \uc0ad\uc81c\ud558\uac70\ub098 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uac70\ub098 \ud558\ub294 \ub370 \uc804\uc801\uc73c\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <em><strong>\uac80\uc0c9 \ubc0f \ub300\uccb4<\/strong><\/em>\ub098\ub294 SQL \ucf54\ub4dc\uac00 \uc815\ub9d0 \uc720\uc6a9\ud558\ub2e4\ub294 \uac83\uc744 \ubab0\ub790\uc5b4. <\/p>\n\n\n\n<p>\ub098\ub294 \uc774 \ucf54\ub4dc\ub4e4\uc744 \uc0ac\uc6a9\ud558\uc5ec \ubc88\uc5ed \uc624\ub958\ub97c \ud655\uc778\ud558\uace0 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0\uc11c \ubc88\uc5ed\ub418\uc9c0 \uc54a\uc740 \ub77c\uc778\uc744 \ucc3e\uc558\ub2e4. <a href=\"https:\/\/kevinbk.com\/ko\/como-eu-traduzi-meu-site-com-translatepress\/\" data-type=\"post\" data-id=\"2550\">\ud2b8\ub79c\uc2ac\ub808\uc774\ud2b8\ud504\ub808\uc2a4<\/a>. <\/p>\n\n\n<div class=\"wp-block-image\" data-no-translation=\"\" data-no-auto-translation=\"\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"900\" height=\"550\" src=\"https:\/\/i0.wp.com\/kevinbk.com\/wp-content\/uploads\/2022\/08\/sql-filtro-navicat.png?resize=900%2C550\" alt=\"-\" class=\"wp-image-3554\" title=\"\" srcset=\"https:\/\/i0.wp.com\/kevinbk.com\/wp-content\/uploads\/2022\/08\/sql-filtro-navicat.png?w=900&amp;ssl=1 900w, https:\/\/i0.wp.com\/kevinbk.com\/wp-content\/uploads\/2022\/08\/sql-filtro-navicat.png?resize=768%2C469&amp;ssl=1 768w, https:\/\/i0.wp.com\/kevinbk.com\/wp-content\/uploads\/2022\/08\/sql-filtro-navicat.png?resize=18%2C12&amp;ssl=1 18w, https:\/\/i0.wp.com\/kevinbk.com\/wp-content\/uploads\/2022\/08\/sql-filtro-navicat.png?resize=150%2C92&amp;ssl=1 150w\" sizes=\"(max-width: 900px) 100vw, 900px\" data-recalc-dims=\"1\" data-no-translation=\"\" data-no-auto-translation=\"\" \/><\/figure><\/div>\n\n\n<h3 class=\"wp-block-heading\"><strong>SQL \ucffc\ub9ac \ucf54\ub4dc<\/strong><\/h3>\n\n\n\n<p>\uc544\ub798 \ucf54\ub4dc\ub294 \ub2e4\uc74c\uacfc \uac19\uc740 \uc6a9\ub3c4\uc5d0 \uc720\uc6a9\ud569\ub2c8\ub2e4: <\/p>\n\n\n\n<ul><li>\ub2e4\ub978 \uc5f4\uc758 \uac19\uc740 \ud589\uc744 \ucc3e\ub2e4;<\/li><li>\ub2e4\ub978 \ud589\uc5d0\uc11c \ub2e4\ub978 \uc5f4 \ucc3e\uae30;<\/li><li>\ub450 \uc5f4\uc5d0\uc11c \ub3d9\uc77c\ud55c \ucf58\ud150\uce20\ub97c \ucc3e\uc2b5\ub2c8\ub2e4; <\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM `databasename`.`tablename` WHERE colum01 = colum02 ORDER BY `id` LIMIT 500 OFFSET 0; <\/code><\/pre>\n\n\n\n<p>\uc6b0\ub9ac\uac00 \ubc29\uae08 \ubcf8 \ucf54\ub4dc\ub294 <strong>WHERE colum01 = colum02<\/strong> \ub450 \uc5f4\uc5d0\uc11c \ub3d9\uc77c\ud55c \uacb0\uacfc\ub97c \uac00\uc9c4 \ud589\uc744 \ud45c\uc2dc\ud558\ub824\uba74\uc774 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud558\uc2ed\uc2dc\uc624. \uc6d0\ud558\ub294 \uacbd\uc6b0 \ub354 \ub9ce\uc740 \uc5f4\uc5d0 \ub300\ud574 \ucf54\ub4dc\ub97c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <\/p>\n\n\n\n<p>\ub9cc\uc57d \ud2b9\uc815 \ud14d\uc2a4\ud2b8\ub97c \ucc3e\uae30 \uc704\ud574 \uc804\ud1b5\uc801\uc778 \ud544\ud130\ub97c \ucd94\uac00\ud558\uace0 \uc2f6\ub2e4\uba74, \uc2a4\ud06c\ub9bd\ud2b8\ub97c \ud655\uc7a5\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. <strong>\uc8fc\ubb38\ud558\uae30<\/strong> \ub193\uae30 <strong>\uadf8\ub9ac\uace0<\/strong> \uc704\uc758 \ucf54\ub4dc\uc640 \uac19\uc774: <\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\"><code class=\"\">SELECT * FROM `databasename`.`tablename` WHERE colum01 = colum02 AND (`colum01` LIKE '%text%') ORDER BY `id` LIMIT 500 OFFSET 0; <\/code><\/pre>\n\n\n\n<p>\ub098\uc911\uc5d0 <strong>\uadf8\ub9ac\uace0<\/strong> \uc6b0\ub9ac\ub294 \uad04\ud638 \uc548\uc5d0 \uc788\ub294 \ucf54\ub4dc\uac00 \ud14d\uc2a4\ud2b8\ub97c 01\uc5f4\uc5d0\uc11c\ub9cc \ud544\ud130\ub9c1\ud55c\ub2e4\uace0 \ud558\ub124\uc694. <strong>\uc88b\uc544\uc694<\/strong> \ud544\ud130\ub41c \uac12\uc744 \ud3ec\ud568\ud558\ub294 \uc904\uc744 \ucc3e\uc73c\ub824\uba74 <strong>N\u00c3O GOSTAR<\/strong> \uac12\uc774 \ud3ec\ud568\ub418\uc9c0 \uc54a\ub294 \ub77c\uc778\uc744 \ucc3e\uc73c\ub824\uba74. <\/p>\n\n\n\n<p>O \uc2a4\ud06c\ub9bd\ud2b8 pode ser \ub354 \ud655\uc7a5\ub418\uc5b4 AND \ubc0f \uae30\ud0c0 \ucf54\ub4dc\ub97c \uc0ac\uc6a9\ud569\ub2c8\ub2e4. \uc774\uc81c \ub05d\ub0b4\uae30 \uc704\ud574 \ub2e4\ub978 \ucf54\ub4dc\ub97c \ud45c\uc2dc\ud560 \uac83\uc785\ub2c8\ub2e4. \uac12\uc774 \ub3d9\uc77c\ud55c \ud589\uc744 \ud45c\uc2dc\ud558\ub294 \ub300\uc2e0, \uac12\uc774 \ub2e4\ub978 \ud589\uc744 \ud45c\uc2dc\ud569\ub2c8\ub2e4.<strong> !=<\/strong>. <\/p>\n\n\n\n<pre class=\"wp-block-code\" data-no-translation=\"\"><code lang=\"sql\" class=\"language-sql\">SELECT * FROM `databasename`.`tablename` WHERE colum01 != colum02 ORDER BY `id` LIMIT 500 OFFSET 0; <\/code><\/pre>\n\n\n\n<p>\ub098\ub294 \uadf8 \ucf54\ub4dc\uac00 \uc2e4\uc81c\ub85c \uc77c\ubc18\uc801\uc778 \ud544\ud130\ub97c \uc0ac\uc6a9\ud558\uc5ec \uac12\uc774 \uac19\uac70\ub098 \ub2e4\ub978 \uc5f4\uc5d0\uc11c \ud589\uc744 \uc815\ud655\ud788 \ud544\ud130\ub9c1\ud558\uace0 \ucc3e\uc744 \uc218 \uc788\uae30\ub97c \ubc14\ub78d\ub2c8\ub2e4 <strong>\uc88b\uc544\uc694\uc640 \uc2eb\uc5b4\uc694<\/strong>. <\/p>","protected":false},"excerpt":{"rendered":"<p>SQL, MySQL \ub610\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ud14c\uc774\ube14\uc5d0\uc11c \ub3d9\uc77c\ud55c \uc5f4\uc744 \uae30\ubc18\uc73c\ub85c \ud589\uc744 \ud544\ud130\ub9c1\ud558\ub294 \ubc29\ubc95\uc744 \ucc3e\uace0 \uc788\uc2b5\ub2c8\uae4c?<\/p>","protected":false},"author":1,"featured_media":2551,"comment_status":"open","ping_status":" ","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/kevinbk.com\/wp-content\/uploads\/2021\/01\/banco-de-dados.png","_links":{"self":[{"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/posts\/3552"}],"collection":[{"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/comments?post=3552"}],"version-history":[{"count":4,"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/posts\/3552\/revisions"}],"predecessor-version":[{"id":3557,"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/posts\/3552\/revisions\/3557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/media\/2551"}],"wp:attachment":[{"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/media?parent=3552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinbk.com\/ko\/wp-json\/wp\/v2\/categories?post=3552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}