{"id":3416,"date":"2016-07-26T15:09:42","date_gmt":"2016-07-26T15:09:42","guid":{"rendered":"https:\/\/kiencang.net\/?p=3416"},"modified":"2016-07-26T15:09:42","modified_gmt":"2016-07-26T15:09:42","slug":"toan-tu-like-trong-sql","status":"publish","type":"post","link":"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/","title":{"rendered":"To\u00e1n t\u1eed LIKE trong SQL"},"content":{"rendered":"\n

To\u00e1n t\u1eed LIKE<\/code> \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t m\u1eabu ch\u1ec9 \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t.<\/p>\n\n\n\n

C\u00fa ph\u00e1p SQL LIKE:<\/p>\n\n\n\n

SELECT ten_cot(c\u00f3 th\u1ec3 nhi\u1ec1u c\u1ed9t)\nFROM ten_bang\nWHERE ten_cot LIKE mau;<\/code><\/pre>\n\n\n\n
\n\n\n\n
C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo<\/h2>\n\n\n\n
Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn.<\/p>\n\n\n\n
D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”:<\/p>\n\n\n\n
CustomerID<\/th>CustomerName<\/th>ContactName<\/th>Address<\/th>City<\/th>PostalCode<\/th>Country<\/th><\/tr>
1<\/td>Alfreds Futterkiste<\/td>Maria Anders<\/td>Obere Str. 57<\/td>Berlin<\/td>12209<\/td>Germany<\/td><\/tr>
2<\/td>Ana Trujillo Emparedados y helados<\/td>Ana Trujillo<\/td>Avda. de la Constituci\u00f3n 2222<\/td>M\u00e9xico D.F.<\/td>05021<\/td>Mexico<\/td><\/tr>
3<\/td>Antonio Moreno Taquer\u00eda<\/td>Antonio Moreno<\/td>Mataderos 2312<\/td>M\u00e9xico D.F.<\/td>05023<\/td>Mexico<\/td><\/tr>
4<\/td>Around the Horn<\/td>Thomas Hardy<\/td>120 Hanover Sq.<\/td>London<\/td>WA1 1DP<\/td>UK<\/td><\/tr>
5<\/td>Berglunds snabbk\u00f6p<\/td>Christina Berglund<\/td>Berguvsv\u00e4gen 8<\/td>Lule\u00e5<\/td>S-958 22<\/td>Sweden<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n
\n\n\n\n
V\u00ed d\u1ee5 v\u1ec1 to\u00e1n t\u1eed SQL LIKE<\/h2>\n\n\n\n
C\u00e2u l\u1ec7nh SQL sau \u0111\u00e2y l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c kh\u00e1ch h\u00e0ng c\u00f3 City b\u1eaft \u0111\u1ea7u v\u1edbi k\u00fd t\u1ef1 “s”<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/p>\n\n\n\n
SELECT * FROM Customers\nWHERE City LIKE 's%';<\/code><\/pre>\n\n\n\n
M\u1eb9o<\/strong>: K\u00fd t\u1ef1 “%” \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 \u0111\u1ecbnh ngh\u0129a c\u00e1c k\u00fd hi\u1ec7u (c\u00e1c k\u00fd t\u1ef1 b\u1ecb m\u1ea5t) c\u1ea3 tr\u01b0\u1edbc v\u00e0 sau m\u1eabu. B\u1ea1n s\u1ebd h\u1ecdc v\u1ec1 c\u00e1c k\u00fd hi\u1ec7u (wildcards) trong ch\u01b0\u01a1ng k\u1ebf.<\/p>\n\n\n\n
—<\/p>\n\n\n\n
C\u00e2u l\u1ec7nh SQL sau l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c kh\u00e1ch h\u00e0ng v\u1edbi City k\u1ebft th\u00fac v\u1edbi k\u00fd t\u1ef1 “s”:<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/p>\n\n\n\n
SELECT * FROM Customers\nWHERE City LIKE '%s';<\/code><\/pre>\n\n\n\n
—<\/p>\n\n\n\n
C\u00e2u l\u1ec7nh SQL sau l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1 kh\u00e1ch h\u00e0ng v\u1edbi Country bao g\u1ed3m m\u1eabu “land”:<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/p>\n\n\n\n
SELECT * FROM Customers\nWHERE Country LIKE '%land%';<\/code><\/pre>\n\n\n\n
—<\/p>\n\n\n\n
S\u1eed d\u1ee5ng t\u1eeb kho\u00e1 NOT<\/code> cho ph\u00e9p b\u1ea1n l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi KH\u00d4NG ph\u00f9 h\u1ee3p v\u1edbi m\u1eabu.<\/p>\n\n\n\n
C\u00e2u l\u1ec7nh SQL sau l\u1ef1a ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c kh\u00e1ch h\u00e0ng v\u1edbi Country KH\u00d4NG bao g\u1ed3m m\u1eabu “land”:<\/p>\n\n\n\n
V\u00ed d\u1ee5:<\/p>\n\n\n\n
SELECT * FROM Customers\nWHERE Country NOT LIKE '%land%';<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"
To\u00e1n t\u1eed LIKE \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t m\u1eabu ch\u1ec9 \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t. C\u00fa ph\u00e1p SQL LIKE: C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”: CustomerID CustomerName ContactName …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[239],"tags":[],"yoast_head":"\nTo\u00e1n t\u1eed LIKE trong SQL • Ki\u1ebfn c\u00e0ng<\/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:\/\/kiencang.net\/toan-tu-like-trong-sql\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"To\u00e1n t\u1eed LIKE trong SQL • Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"og:description\" content=\"To\u00e1n t\u1eed LIKE \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t m\u1eabu ch\u1ec9 \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t. C\u00fa ph\u00e1p SQL LIKE: C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”: CustomerID CustomerName ContactName …\" \/>\n<meta property=\"og:url\" content=\"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/\" \/>\n<meta property=\"og:site_name\" content=\"Ki\u1ebfn c\u00e0ng\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/anhducnguyen87\/\" \/>\n<meta property=\"article:published_time\" content=\"2016-07-26T15:09:42+00:00\" \/>\n<meta name=\"author\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Nguy\u1ec5n \u0110\u1ee9c Anh\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 ph\u00fat\" \/>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"To\u00e1n t\u1eed LIKE trong SQL • Ki\u1ebfn c\u00e0ng","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:\/\/kiencang.net\/toan-tu-like-trong-sql\/","og_locale":"vi_VN","og_type":"article","og_title":"To\u00e1n t\u1eed LIKE trong SQL • Ki\u1ebfn c\u00e0ng","og_description":"To\u00e1n t\u1eed LIKE \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ecm ki\u1ebfm m\u1ed9t m\u1eabu ch\u1ec9 \u0111\u1ecbnh trong m\u1ed9t c\u1ed9t. C\u00fa ph\u00e1p SQL LIKE: C\u01a1 s\u1edf d\u1eef li\u1ec7u Demo Trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng c\u01a1 s\u1edf d\u1eef li\u1ec7u m\u1eabu Northwind \u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t l\u1ef1a ch\u1ecdn t\u1eeb b\u1ea3ng “Customers”: CustomerID CustomerName ContactName …","og_url":"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/","og_site_name":"Ki\u1ebfn c\u00e0ng","article_author":"https:\/\/www.facebook.com\/anhducnguyen87\/","article_published_time":"2016-07-26T15:09:42+00:00","author":"Nguy\u1ec5n \u0110\u1ee9c Anh","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Nguy\u1ec5n \u0110\u1ee9c Anh","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"2 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/","url":"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/","name":"To\u00e1n t\u1eed LIKE trong SQL • Ki\u1ebfn c\u00e0ng","isPartOf":{"@id":"https:\/\/kiencang.net\/#website"},"datePublished":"2016-07-26T15:09:42+00:00","dateModified":"2016-07-26T15:09:42+00:00","author":{"@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16"},"breadcrumb":{"@id":"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/kiencang.net\/toan-tu-like-trong-sql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/kiencang.net\/toan-tu-like-trong-sql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/kiencang.net\/"},{"@type":"ListItem","position":2,"name":"To\u00e1n t\u1eed LIKE trong SQL"}]},{"@type":"WebSite","@id":"https:\/\/kiencang.net\/#website","url":"https:\/\/kiencang.net\/","name":"Ki\u1ebfn c\u00e0ng","description":"\u00d4m l\u00fd thuy\u1ebft, h\u00f4n th\u1ef1c h\u00e0nh","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/kiencang.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"Person","@id":"https:\/\/kiencang.net\/#\/schema\/person\/5e7e1a04d8d1218ad8c421ba43d25c16","name":"Nguy\u1ec5n \u0110\u1ee9c Anh","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/kiencang.net\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6d71f9b89393952a8382e30dad26c1ec?s=96&d=monsterid&r=g","caption":"Nguy\u1ec5n \u0110\u1ee9c Anh"},"description":"Sinh n\u0103m 1987, t\u1ed1t nghi\u1ec7p Cao \u0111\u1eb3ng th\u1ef1c h\u00e0nh FPT qu\u00e3ng 2014, chuy\u00ean ng\u00e0nh Thi\u1ebft k\u1ebf website. T\u00f4i th\u00edch Content, SEO, Ads, T\u0103ng t\u1ed1c website v\u00e0 Th\u01b0\u01a1ng m\u1ea1i \u0111i\u1ec7n t\u1eed. B\u00ean c\u1ea1nh b\u00e0i t\u1ef1 vi\u1ebft, t\u00f4i c\u0169ng d\u1ecbch nhi\u1ec1u n\u1ed9i dung th\u00fa v\u1ecb c\u1ee7a c\u00e1c t\u00e1c gi\u1ea3 kh\u00e1c nhau. FB c\u00e1 nh\u00e2n: facebook.com\/anhducnguyen87. Email li\u00ean h\u1ec7: guiemailchotoi@gmail.com","sameAs":["https:\/\/www.facebook.com\/anhducnguyen87\/"],"url":"https:\/\/kiencang.net\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3416"}],"collection":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/comments?post=3416"}],"version-history":[{"count":0,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/posts\/3416\/revisions"}],"wp:attachment":[{"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/media?parent=3416"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/categories?post=3416"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kiencang.net\/wp-json\/wp\/v2\/tags?post=3416"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}