{"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\/vi\/filter-by-same-column-in-databases-with-sql-query\/","title":{"rendered":"L\u1ecdc theo c\u00e1c c\u1ed9t gi\u1ed1ng h\u1ec7t nhau trong c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u1edbi truy v\u1ea5n SQL"},"content":{"rendered":"<p>T\u00ecm c\u00e1ch l\u1ecdc c\u00e1c h\u00e0ng c\u1ee7a b\u1ea1n t\u1eeb b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u SQL, MySQL ho\u1eb7c MariaDB theo c\u00e1c c\u1ed9t gi\u1ed1ng h\u1ec7t nhau? B\u1ea1n \u0111ang t\u00ecm m\u1ed9t Truy v\u1ea5n \u0111\u1ec3 ch\u01a1i tr\u00ean b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n? <\/p>\n\n\n\n<p>G\u1ea7n \u0111\u00e2y t\u00f4i \u0111\u00e3 g\u1eb7p ph\u1ea3i t\u00ecnh hu\u1ed1ng c\u1ea7n ph\u1ea3i l\u1ecdc tr\u00ean b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u v\u00e0 ch\u1ec9 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng c\u00f3 hai c\u1ed9t c\u00f3 c\u00f9ng gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n. Sau nhi\u1ec1u gi\u1edd t\u00ecm ki\u1ebfm, t\u00f4i \u0111\u00e3 t\u00ecm th\u1ea5y gi\u1ea3i ph\u00e1p \u0111\u01a1n gi\u1ea3n v\u00e0 t\u00f4i \u0111ang chia s\u1ebb n\u00f3 v\u1edbi b\u1ea1n. <\/p>\n\n\n\n<p>T\u00f4i kh\u00f4ng ph\u1ea3i l\u00e0 l\u1eadp tr\u00ecnh vi\u00ean, v\u00e0 t\u00f4i tin r\u1eb1ng h\u1ea7u h\u1ebft nh\u1eefng ng\u01b0\u1eddi t\u00ecm ki\u1ebfm nh\u1eefng m\u1eb9o n\u00e0y c\u0169ng kh\u00f4ng c\u00f3 nhi\u1ec1u c\u1ea3m gi\u00e1c v\u1ec1 m\u00e3. <\/p>\n\n\n\n<p>T\u00f4i th\u01b0\u1eddng s\u1eed d\u1ee5ng ch\u01b0\u01a1ng tr\u00ecnh Navicat \u0111\u1ec3 ch\u1ec9nh s\u1eeda c\u01a1 s\u1edf d\u1eef li\u1ec7u, n\u00f3 kh\u00e1 nhanh v\u00e0 ti\u1ec7n l\u1ee3i, ngo\u00e0i ra c\u00f2n cho ph\u00e9p b\u1ea1n ch\u1ec9nh s\u1eeda c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t t\u1ef1 do ngang v\u1edbi Microsoft Excel ho\u1eb7c Apple Numbers.<\/p>\n\n\n\n<p>H\u1ea7u h\u1ebft m\u1ecdi ng\u01b0\u1eddi s\u1eed d\u1ee5ng PhpmyAdmin \u0111\u1ec3 qu\u1ea3n l\u00fd c\u01a1 s\u1edf d\u1eef li\u1ec7u trang web c\u1ee7a h\u1ecd. C\u1ea3 hai \u0111\u1ec1u cho ph\u00e9p b\u1ea1n ch\u1ea1y c\u00e1c t\u1eadp l\u1ec7nh th\u00f4ng qua SQL ho\u1eb7c tab Truy v\u1ea5n. <\/p>\n\n\n\n<h2 class=\"wp-block-heading\">S\u1eed d\u1ee5ng truy v\u1ea5n SQL \u0111\u1ec3 l\u1ecdc<\/h2>\n\n\n\n<p>V\u00ec t\u00f4i kh\u00f4ng ph\u1ea3i l\u00e0 chuy\u00ean gia v\u1ec1 c\u01a1 s\u1edf d\u1eef li\u1ec7u n\u00ean t\u00f4i kh\u00f4ng bi\u1ebft r\u1eb1ng b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c b\u1ea3ng \u0111\u00e3 l\u1ecdc th\u00f4ng qua m\u00e3 truy v\u1ea5n, nh\u01b0ng may m\u1eafn l\u00e0 t\u00f4i \u0111\u00e3 ph\u00e1t hi\u1ec7n ra. <\/p>\n\n\n\n<p>Vi\u1ec7c s\u1eed d\u1ee5ng c\u1ee7a t\u00f4i trong c\u01a1 s\u1edf d\u1eef li\u1ec7u ho\u00e0n to\u00e0n l\u00e0 x\u00f3a c\u00e1c d\u00f2ng, t\u00ecm ki\u1ebfm v\u0103n b\u1ea3n v\u00e0 s\u1eed d\u1ee5ng <em><strong>T\u00ecm ki\u1ebfm v\u00e0 Thay th\u1ebf<\/strong><\/em>, T\u00f4i kh\u00f4ng bi\u1ebft r\u1eb1ng m\u00e3 SQL si\u00eau h\u1eefu \u00edch. <\/p>\n\n\n\n<p>C\u00e1 nh\u00e2n t\u00f4i \u0111\u00e3 s\u1eed d\u1ee5ng c\u00e1c m\u00e3 n\u00e0y \u0111\u1ec3 ki\u1ec3m tra l\u1ed7i d\u1ecbch v\u00e0 t\u00ecm c\u00e1c h\u00e0ng ch\u01b0a \u0111\u01b0\u1ee3c d\u1ecbch trong b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u c\u1ee7a <a href=\"https:\/\/kevinbk.com\/vi\/how-i-translate-my-site-with-translatepress\/\" data-type=\"post\" data-id=\"2550\">d\u1ecbch b\u00e1o ch\u00ed<\/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>M\u00e3 truy v\u1ea5n SQL<\/strong><\/h3>\n\n\n\n<p>C\u00e1c m\u00e3 d\u01b0\u1edbi \u0111\u00e2y h\u1eefu \u00edch cho: <\/p>\n\n\n\n<ul><li>T\u00ecm c\u00e1c h\u00e0ng b\u1eb1ng nhau t\u1eeb c\u00e1c c\u1ed9t kh\u00e1c nhau;<\/li><li>T\u00ecm c\u00e1c h\u00e0ng kh\u00e1c nhau t\u1eeb c\u00e1c c\u1ed9t kh\u00e1c nhau;<\/li><li>T\u00ecm n\u1ed9i dung b\u1eb1ng nhau trong hai c\u1ed9t; <\/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>\u0110o\u1ea1n m\u00e3 ch\u00fang ta v\u1eeba xem x\u00e9t c\u00e1ch s\u1eed d\u1ee5ng <strong>WHERE colum01 = colum02<\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng c\u00f3 c\u00f9ng k\u1ebft qu\u1ea3 trong c\u1ea3 hai c\u1ed9t. M\u00e3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng \u0111\u1ebfn nhi\u1ec1u c\u1ed9t h\u01a1n n\u1ebfu mu\u1ed1n. <\/p>\n\n\n\n<p>Trong tr\u01b0\u1eddng h\u1ee3p b\u1ea1n mu\u1ed1n th\u00eam c\u00e1c b\u1ed9 l\u1ecdc truy\u1ec1n th\u1ed1ng \u0111\u1ec3 t\u00ecm v\u0103n b\u1ea3n nh\u1ea5t \u0111\u1ecbnh, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng t\u1eadp l\u1ec7nh tr\u01b0\u1edbc <strong>\u0110\u1eb6T B\u1edeI<\/strong> \u0111\u1eb7t m\u1ed9t <strong>V\u00c0<\/strong> nh\u01b0 trong \u0111o\u1ea1n m\u00e3 d\u01b0\u1edbi \u0111\u00e2y: <\/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>Sau <strong>V\u00c0<\/strong> ch\u00fang t\u00f4i c\u00f3 m\u1ed9t m\u00e3 trong ngo\u1eb7c \u0111\u01a1n ch\u1ec9 l\u1ecdc v\u0103n b\u1ea3n trong c\u1ed9t 01. <strong>GI\u1ed0NG<\/strong> \u0111\u1ec3 t\u00ecm c\u00e1c d\u00f2ng c\u00f3 ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u00e3 l\u1ecdc ho\u1eb7c <strong>KH\u00d4NG TH\u00cdCH<\/strong> \u0111\u1ec3 t\u00ecm c\u00e1c h\u00e0ng kh\u00f4ng ch\u1ee9a gi\u00e1 tr\u1ecb. <\/p>\n\n\n\n<p>T\u1eadp l\u1ec7nh c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng th\u00eam b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng AND v\u00e0 m\u00e3 kh\u00e1c. B\u00e2y gi\u1edd \u0111\u1ec3 k\u1ebft th\u00fac, ch\u00fang ta s\u1ebd hi\u1ec3n th\u1ecb m\u1ed9t m\u00e3 kh\u00e1c, nh\u01b0ng thay v\u00ec hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb b\u1eb1ng nhau, n\u00f3 hi\u1ec3n th\u1ecb c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb kh\u00e1c nhau b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng<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>Hy v\u1ecdng m\u00e3 n\u00e0y s\u1ebd gi\u00fap b\u1ea1n th\u1ef1c s\u1ef1 l\u1ecdc v\u00e0 t\u00ecm ki\u1ebfm c\u00e1c h\u00e0ng c\u00f3 gi\u00e1 tr\u1ecb gi\u1ed1ng ho\u1eb7c kh\u00e1c t\u1eeb c\u00e1c c\u1ed9t ri\u00eang bi\u1ec7t b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng b\u1ed9 l\u1ecdc th\u00f4ng th\u01b0\u1eddng <strong>TH\u00cdCH v\u00e0 KH\u00d4NG TH\u00cdCH<\/strong>. <\/p>","protected":false},"excerpt":{"rendered":"<p>T\u00ecm c\u00e1ch l\u1ecdc c\u00e1c h\u00e0ng c\u1ee7a b\u1ea1n t\u1eeb b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u SQL, MySQL ho\u1eb7c MySQL theo c\u00e1c c\u1ed9t gi\u1ed1ng h\u1ec7t nhau?<\/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\/vi\/wp-json\/wp\/v2\/posts\/3552"}],"collection":[{"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/comments?post=3552"}],"version-history":[{"count":4,"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/posts\/3552\/revisions"}],"predecessor-version":[{"id":3557,"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/posts\/3552\/revisions\/3557"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/media\/2551"}],"wp:attachment":[{"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/media?parent=3552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kevinbk.com\/vi\/wp-json\/wp\/v2\/categories?post=3552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}