{"id":8899,"date":"2024-12-29T05:58:34","date_gmt":"2024-12-29T05:58:34","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like\/"},"modified":"2024-12-29T05:58:34","modified_gmt":"2024-12-29T05:58:34","slug":"lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like\/","title":{"rendered":"L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 3 \u2013 l\u1ecdc n\u00e2ng cao v\u1edbi LIKE"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong>N\u1ed9i dung ch\u00ednh<\/strong><\/p>\n<ul id=\"markdown-toc\">\n<li><a id=\"markdown-toc-nhng-v-d-v-lc-d-liu-theo-iu-kin-s-dng-t-kho-like-kt-hp-vi-where-trong-sql\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#nhng-v-d-v-lc-d-liu-theo-iu-kin-s-dng-t-kho-like-kt-hp-vi-where-trong-sql\">Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 LIKE k\u1ebft h\u1ee3p v\u1edbi WHERE trong SQL<\/a>\n<ul>\n<li><a id=\"markdown-toc-gii-thiu-v-t-kho-like-trong-sql\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#gii-thiu-v-t-kho-like-trong-sql\">1. Gi\u1edbi thi\u1ec7u v\u1ec1 t\u1eeb kho\u00e1 LIKE trong SQL<\/a><\/li>\n<li><a id=\"markdown-toc-k-t-phn-trm--v-k-t-gch-ni-di--c-s-dng-cng-vi-t-kho-like\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#k-t-phn-trm--v-k-t-gch-ni-di--c-s-dng-cng-vi-t-kho-like\">2. K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m <code class=\"highlighter-rouge\">%<\/code> v\u00e0 k\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi <code class=\"highlighter-rouge\">_<\/code> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code><\/a>\n<ul>\n<li><a id=\"markdown-toc-k-t-phn-trm-\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#k-t-phn-trm-\">K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m <code class=\"highlighter-rouge\">%<\/code><\/a><\/li>\n<li><a id=\"markdown-toc-k-t-gch-ni-di-\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#k-t-gch-ni-di-\">K\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi <code class=\"highlighter-rouge\">_<\/code><\/a><\/li>\n<\/ul>\n<\/li>\n<li><a id=\"markdown-toc-cc-v-d-v-cu-lnh-sql-vi-like\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#cc-v-d-v-cu-lnh-sql-vi-like\">3. C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00e2u l\u1ec7nh SQL v\u1edbi LIKE<\/a>\n<ul>\n<li><a id=\"markdown-toc-tm-tt-c-nhng-ngi-bn-hng-m-tn-c-ch-ci-u-l-k\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#tm-tt-c-nhng-ngi-bn-hng-m-tn-c-ch-ci-u-l-k\">T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng ng\u01b0\u1eddi b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">K<\/code><\/a><\/li>\n<li><a id=\"markdown-toc-tm-tt-c-nhng-mt-hng-m-tn-mt-hng-c-2-ch-ci-u-l-pe\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#tm-tt-c-nhng-mt-hng-m-tn-mt-hng-c-2-ch-ci-u-l-pe\">T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng m\u1eb7t h\u00e0ng m\u00e0 t\u00ean m\u1eb7t h\u00e0ng c\u00f3 2 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">Pe<\/code><\/a><\/li>\n<li><a id=\"markdown-toc-tm-tt-c-nhng-nhn-vin-bn-hng-m-tn-c-ch-ci-u-l-j-v-ch-ci-cui-l-s\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#tm-tt-c-nhng-nhn-vin-bn-hng-m-tn-c-ch-ci-u-l-j-v-ch-ci-cui-l-s\">T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">J<\/code> v\u00e0 ch\u1eef c\u00e1i cu\u1ed1i l\u00e0 <code class=\"highlighter-rouge\">s<\/code><\/a><\/li>\n<li><a id=\"markdown-toc-tm-tt-c-cc-mt-hng-m-s-lng-bn-units-t-20-n-29\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#tm-tt-c-cc-mt-hng-m-s-lng-bn-units-t-20-n-29\">T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng m\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n <code class=\"highlighter-rouge\">Units<\/code> t\u1eeb <code class=\"highlighter-rouge\">20<\/code> \u0111\u1ebfn <code class=\"highlighter-rouge\">29<\/code><\/a><\/li>\n<li><a id=\"markdown-toc-tm-tt-c-cc-mt-hng-c-tn-bt-u-bng-ch-p-v-c-3-k-t\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#tm-tt-c-cc-mt-hng-c-tn-bt-u-bng-ch-p-v-c-3-k-t\">T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef <code class=\"highlighter-rouge\">P<\/code> v\u00e0 c\u00f3 3 k\u00ed t\u1ef1<\/a><\/li>\n<li><a id=\"markdown-toc-tm-tt-c-cc-nhn-vin-m-tn-kt-thc-bng-ch-s\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#tm-tt-c-cc-nhn-vin-m-tn-kt-thc-bng-ch-s\">T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c nh\u00e2n vi\u00ean m\u00e0 t\u00ean k\u1ebft th\u00fac b\u1eb1ng ch\u1eef <code class=\"highlighter-rouge\">s<\/code><\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li><a id=\"markdown-toc-chng-ta--lm-g-trong-bi-vit-ny\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#chng-ta--lm-g-trong-bi-vit-ny\">Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<\/a><\/li>\n<li><a id=\"markdown-toc-download-ti-liu-km-theo-video\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#download-ti-liu-km-theo-video\">Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/a><\/li>\n<li><a id=\"markdown-toc-cc-kin-thc-lin-quan\" href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html#cc-kin-thc-lin-quan\">C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan<\/a><\/li>\n<\/ul>\n<hr>\n<p>Trong b\u00e0i <a href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html\" rel=\"noopener nofollow\"><strong>\u0111\u1ea7u ti\u00ean<\/strong><\/a> v\u00e0 <a href=\"http:\/\/www.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html\" rel=\"noopener nofollow\"><strong>b\u00e0i th\u1ee9 2<\/strong><\/a> c\u1ee7a series <strong>L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel<\/strong>, c\u00e1c b\u1ea1n \u0111\u00e3 l\u00e0m quen v\u1edbi c\u00e1ch s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SELECT<\/code> v\u00e0 <code class=\"highlighter-rouge\">WHERE<\/code> \u0111\u1ec3 truy v\u1ea5n d\u1eef li\u1ec7u t\u1eeb 1 b\u1ea3ng t\u00ednh cho s\u1eb5n. Trong b\u00e0i n\u00e0y, ch\u00fang ta s\u1ebd m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n h\u01a1n n\u1eefa b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code> trong <code class=\"highlighter-rouge\">SQL<\/code>. T\u1ea5t c\u1ea3 c\u00e1c v\u00ed d\u1ee5 trong b\u00e0i n\u00e0y \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n b\u00ean trong <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\"><strong>file excel n\u00e0y<\/strong><\/a> v\u00e0 c\u00e1c b\u1ea1n n\u00ean xem video \u0111\u1ec3 bi\u1ebft th\u00eam chi ti\u1ebft.<\/p>\n<iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/-gsMj4seais?list=PLALCv46JuKELXd5Ie81UqaFqAfsoXQSQt&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe>\n<p><a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Download excel file k\u00e8m theo video<\/strong><\/a><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-6770e509c01b3\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Nhung_vi_du_ve_loc_du_lieu_theo_dieu_kien_su_dung_tu_khoa_LIKE_ket_hop_voi_WHERE_trong_SQL\" title=\"Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 LIKE k\u1ebft h\u1ee3p v\u1edbi WHERE trong SQL\">Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 LIKE k\u1ebft h\u1ee3p v\u1edbi WHERE trong SQL<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#1_Gioi_thieu_ve_tu_khoa_LIKE_trong_SQL\" title=\"1. Gi\u1edbi thi\u1ec7u v\u1ec1 t\u1eeb kho\u00e1 LIKE trong SQL\">1. Gi\u1edbi thi\u1ec7u v\u1ec1 t\u1eeb kho\u00e1 LIKE trong SQL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#2_Ki_tu_phan_tram_va_ki_tu_gach_noi_duoi_duoc_su_dung_cung_voi_tu_khoa_LIKE\" title=\"2. K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m % v\u00e0 k\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi _ \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi t\u1eeb kho\u00e1 LIKE\">2. K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m % v\u00e0 k\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi _ \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi t\u1eeb kho\u00e1 LIKE<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Ki_tu_phan_tram\" title=\"K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m %\">K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m %<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Ki_tu_gach_noi_duoi\" title=\"K\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi _\">K\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi _<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#3_Cac_vi_du_ve_cau_lenh_SQL_voi_LIKE\" title=\"3. C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00e2u l\u1ec7nh SQL v\u1edbi LIKE\">3. C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00e2u l\u1ec7nh SQL v\u1edbi LIKE<\/a>\n<ul class=\"ez-toc-list-level-5\">\n<li class=\"ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Tim_tat_ca_nhung_nguoi_ban_hang_ma_ten_co_chu_cai_dau_la_K\" title=\"T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng ng\u01b0\u1eddi b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 K\">T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng ng\u01b0\u1eddi b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 K<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Tim_tat_ca_nhung_mat_hang_ma_ten_mat_hang_co_2_chu_cai_dau_la_Pe\" title=\"T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng m\u1eb7t h\u00e0ng m\u00e0 t\u00ean m\u1eb7t h\u00e0ng c\u00f3 2 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 Pe\">T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng m\u1eb7t h\u00e0ng m\u00e0 t\u00ean m\u1eb7t h\u00e0ng c\u00f3 2 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 Pe<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Tim_tat_ca_nhung_nhan_vien_ban_hang_ma_ten_co_chu_cai_dau_la_J_va_chu_cai_cuoi_la_s\" title=\"T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 J v\u00e0 ch\u1eef c\u00e1i cu\u1ed1i l\u00e0 s\">T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 J v\u00e0 ch\u1eef c\u00e1i cu\u1ed1i l\u00e0 s<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Tim_tat_ca_cac_mat_hang_ma_so_luong_ban_Units_tu_20_den_29\" title=\"T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng m\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n Units t\u1eeb 20 \u0111\u1ebfn 29\">T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng m\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n Units t\u1eeb 20 \u0111\u1ebfn 29<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Tim_tat_ca_cac_mat_hang_co_ten_bat_dau_bang_chu_P_va_co_3_ki_tu\" title=\"T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef P v\u00e0 c\u00f3 3 k\u00ed t\u1ef1\">T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef P v\u00e0 c\u00f3 3 k\u00ed t\u1ef1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-5\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Tim_tat_ca_cac_nhan_vien_ma_ten_ket_thuc_bang_chu_s\" title=\"T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c nh\u00e2n vi\u00ean m\u00e0 t\u00ean k\u1ebft th\u00fac b\u1eb1ng ch\u1eef s\">T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c nh\u00e2n vi\u00ean m\u00e0 t\u00ean k\u1ebft th\u00fac b\u1eb1ng ch\u1eef s<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-3-loc-nang-cao-voi-like.html#Chung_ta_da_lam_gi_trong_bai_viet_nay\" title=\"Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?\">Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3 id=\"nhng-v-d-v-lc-d-liu-theo-iu-kin-s-dng-t-kho-like-kt-hp-vi-where-trong-sql\"><span class=\"ez-toc-section\" id=\"Nhung_vi_du_ve_loc_du_lieu_theo_dieu_kien_su_dung_tu_khoa_LIKE_ket_hop_voi_WHERE_trong_SQL\"><\/span>Nh\u1eefng v\u00ed d\u1ee5 v\u1ec1 l\u1ecdc d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 LIKE k\u1ebft h\u1ee3p v\u1edbi WHERE trong SQL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ea7u ti\u00ean \u0111\u00e2y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta:<\/p>\n\n<p>\u00e2y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp t\u1eeb <strong>Excel Online<\/strong>, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng m\u1ed9t tr\u00ecnh duy\u1ec7t Web hi\u1ec7n \u0111\u1ea1i (Google Chrome, Firefox, Safari) \u0111\u1ec3 c\u00f3 th\u1ec3 xem \u0111\u01b0\u1ee3c b\u1ea3ng Excel n\u00e0y tr\u1ef1c ti\u1ebfp. T\u00e0i li\u1ec7u Excel n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c download <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>t\u1ea1i \u0111\u00e2y<\/strong><\/a><\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-833.gif\" title=\"ex101_92019-nho-833\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>http:\/\/www.hocexcel.online\/vba101-landing.html<\/p>\n<h4 id=\"gii-thiu-v-t-kho-like-trong-sql\"><span class=\"ez-toc-section\" id=\"1_Gioi_thieu_ve_tu_khoa_LIKE_trong_SQL\"><\/span>1. Gi\u1edbi thi\u1ec7u v\u1ec1 t\u1eeb kho\u00e1 LIKE trong SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code> d\u00f9ng \u0111\u1ec3 so s\u00e1nh m\u1ed9t gi\u00e1 tr\u1ecb v\u1edbi 1 gi\u00e1 tr\u1ecb kh\u00e1c d\u1ef1a v\u00e0o nh\u1eefng k\u00ed t\u1ef1 \u0111\u1ea1i di\u1ec7n ( k\u00ed t\u1ef1 ph\u1ea7n tr\u0103m <code class=\"highlighter-rouge\">%<\/code> ho\u1eb7c d\u1ea5u g\u1ea1ch n\u1ed1i <code class=\"highlighter-rouge\">_<\/code> ). <strong>KH\u00d4NG HI\u1ec2U!!!<\/strong> V\u1edbi t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code> ch\u00fang ta c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm v\u00e0 l\u1ecdc d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<ul>\n<li>T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng ng\u01b0\u1eddi b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">K<\/code><\/li>\n<li>T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng m\u1eb7t h\u00e0ng m\u00e0 t\u00ean m\u1eb7t h\u00e0ng c\u00f3 2 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">Pe<\/code><\/li>\n<li>T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">J<\/code> v\u00e0 ch\u1eef c\u00e1i cu\u1ed1i l\u00e0 <code class=\"highlighter-rouge\">s<\/code><\/li>\n<li>T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng m\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n <code class=\"highlighter-rouge\">Units<\/code> t\u1eeb <code class=\"highlighter-rouge\">20<\/code> \u0111\u1ebfn <code class=\"highlighter-rouge\">29<\/code><\/li>\n<li>\u2026<\/li>\n<\/ul>\n<p>C\u00f3 r\u1ea5t nhi\u1ec1u v\u00ed d\u1ee5 n\u1eefa m\u00e0 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code> \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u.<\/p>\n<h4 id=\"k-t-phn-trm--v-k-t-gch-ni-di--c-s-dng-cng-vi-t-kho-like\"><span class=\"ez-toc-section\" id=\"2_Ki_tu_phan_tram_va_ki_tu_gach_noi_duoi_duoc_su_dung_cung_voi_tu_khoa_LIKE\"><\/span>2. K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m <code class=\"highlighter-rouge\">%<\/code> v\u00e0 k\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi <code class=\"highlighter-rouge\">_<\/code> \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<h5 id=\"k-t-phn-trm-\"><span class=\"ez-toc-section\" id=\"Ki_tu_phan_tram\"><\/span>K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m <code class=\"highlighter-rouge\">%<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>K\u00ed t\u1ef1 ph\u1ea7n tr\u0103m khi s\u1eed d\u1ee5ng c\u00f9ng v\u1edbi t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code> s\u1ebd \u0111\u1ea1i di\u1ec7n cho 0, 1 ho\u1eb7c b\u1ea5t k\u00ec s\u1ed1 l\u01b0\u1ee3ng k\u00ed t\u1ef1 n\u00e0o.<\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> <code class=\"highlighter-rouge\">T%<\/code> s\u1ebd l\u00e0 \u0111\u1ea1i di\u1ec7n cho <code class=\"highlighter-rouge\">T<\/code>, <code class=\"highlighter-rouge\">Thu<\/code>, <code class=\"highlighter-rouge\">Thanh<\/code>, <code class=\"highlighter-rouge\">T3232<\/code>, \u2026<\/p>\n<h5 id=\"k-t-gch-ni-di-\"><span class=\"ez-toc-section\" id=\"Ki_tu_gach_noi_duoi\"><\/span>K\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi <code class=\"highlighter-rouge\">_<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<p>K\u00ed t\u1ef1 g\u1ea1ch n\u1ed1i d\u01b0\u1edbi s\u1ebd \u0111\u1ea1i di\u1ec7n cho \u0111\u00fang 1 k\u00ed t\u1ef1 s\u1ed1 ho\u1eb7c ch\u1eef khi s\u1eed d\u1ee5ng v\u1edbi t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code><\/p>\n<p><strong>V\u00ed d\u1ee5:<\/strong> <code class=\"highlighter-rouge\">T_<\/code> s\u1ebd l\u00e0 \u0111\u1ea1i di\u1ec7n cho <code class=\"highlighter-rouge\">T0<\/code>, <code class=\"highlighter-rouge\">Tu<\/code>, <code class=\"highlighter-rouge\">Ta<\/code>, \u2026<\/p>\n<h4 id=\"cc-v-d-v-cu-lnh-sql-vi-like\"><span class=\"ez-toc-section\" id=\"3_Cac_vi_du_ve_cau_lenh_SQL_voi_LIKE\"><\/span>3. C\u00e1c v\u00ed d\u1ee5 v\u1ec1 c\u00e2u l\u1ec7nh SQL v\u1edbi LIKE<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Sau \u0111\u00e2y l\u00e0 m\u1ed9t lo\u1ea1t c\u00e1c v\u00ed d\u1ee5 v\u1edbi c\u00e2u l\u1ec7nh SQL v\u00e0 k\u1ebft qu\u1ea3 m\u00e0 c\u00e2u l\u1ec7nh \u0111\u00f3 s\u1ebd \u0111\u01b0a l\u1ea1i cho ch\u00fang ta, c\u00e1c b\u1ea1n nh\u1edb <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\"><strong>download file excel<\/strong><\/a> v\u1ec1 v\u00e0 th\u1eed t\u1eebng c\u00e2u n\u00e0y nh\u00e9.<\/p>\n<h5 id=\"tm-tt-c-nhng-ngi-bn-hng-m-tn-c-ch-ci-u-l-k\"><span class=\"ez-toc-section\" id=\"Tim_tat_ca_nhung_nguoi_ban_hang_ma_ten_co_chu_cai_dau_la_K\"><\/span>T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng ng\u01b0\u1eddi b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">K<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Rep<\/span>\r\n\t<span class=\"k\">LIKE<\/span> <span class=\"s1\">'K%'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h5 id=\"tm-tt-c-nhng-mt-hng-m-tn-mt-hng-c-2-ch-ci-u-l-pe\"><span class=\"ez-toc-section\" id=\"Tim_tat_ca_nhung_mat_hang_ma_ten_mat_hang_co_2_chu_cai_dau_la_Pe\"><\/span>T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng m\u1eb7t h\u00e0ng m\u00e0 t\u00ean m\u1eb7t h\u00e0ng c\u00f3 2 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">Pe<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Rep<\/span>\r\n\t<span class=\"k\">LIKE<\/span> <span class=\"s1\">'Pe%'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h5 id=\"tm-tt-c-nhng-nhn-vin-bn-hng-m-tn-c-ch-ci-u-l-j-v-ch-ci-cui-l-s\"><span class=\"ez-toc-section\" id=\"Tim_tat_ca_nhung_nhan_vien_ban_hang_ma_ten_co_chu_cai_dau_la_J_va_chu_cai_cuoi_la_s\"><\/span>T\u00ecm t\u1ea5t c\u1ea3 nh\u1eefng nh\u00e2n vi\u00ean b\u00e1n h\u00e0ng m\u00e0 t\u00ean c\u00f3 ch\u1eef c\u00e1i \u0111\u1ea7u l\u00e0 <code class=\"highlighter-rouge\">J<\/code> v\u00e0 ch\u1eef c\u00e1i cu\u1ed1i l\u00e0 <code class=\"highlighter-rouge\">s<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Rep<\/span>\r\n\t<span class=\"k\">LIKE<\/span> <span class=\"s1\">'J%s'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h5 id=\"tm-tt-c-cc-mt-hng-m-s-lng-bn-units-t-20-n-29\"><span class=\"ez-toc-section\" id=\"Tim_tat_ca_cac_mat_hang_ma_so_luong_ban_Units_tu_20_den_29\"><\/span>T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng m\u00e0 s\u1ed1 l\u01b0\u1ee3ng b\u00e1n <code class=\"highlighter-rouge\">Units<\/code> t\u1eeb <code class=\"highlighter-rouge\">20<\/code> \u0111\u1ebfn <code class=\"highlighter-rouge\">29<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Units<\/span>\r\n\t<span class=\"k\">LIKE<\/span> <span class=\"s1\">'2_'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h5 id=\"tm-tt-c-cc-mt-hng-c-tn-bt-u-bng-ch-p-v-c-3-k-t\"><span class=\"ez-toc-section\" id=\"Tim_tat_ca_cac_mat_hang_co_ten_bat_dau_bang_chu_P_va_co_3_ki_tu\"><\/span>T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c m\u1eb7t h\u00e0ng c\u00f3 t\u00ean b\u1eaft \u0111\u1ea7u b\u1eb1ng ch\u1eef <code class=\"highlighter-rouge\">P<\/code> v\u00e0 c\u00f3 3 k\u00ed t\u1ef1<span class=\"ez-toc-section-end\"><\/span><\/h5>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Item<\/span>\r\n\t<span class=\"k\">LIKE<\/span> <span class=\"s1\">'P__'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h5 id=\"tm-tt-c-cc-nhn-vin-m-tn-kt-thc-bng-ch-s\"><span class=\"ez-toc-section\" id=\"Tim_tat_ca_cac_nhan_vien_ma_ten_ket_thuc_bang_chu_s\"><\/span>T\u00ecm t\u1ea5t c\u1ea3 c\u00e1c nh\u00e2n vi\u00ean m\u00e0 t\u00ean k\u1ebft th\u00fac b\u1eb1ng ch\u1eef <code class=\"highlighter-rouge\">s<\/code><span class=\"ez-toc-section-end\"><\/span><\/h5>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n\t<span class=\"k\">WHERE<\/span> <span class=\"n\">Rep<\/span>\r\n\t<span class=\"k\">LIKE<\/span> <span class=\"s1\">'%s'<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<h3 id=\"chng-ta--lm-g-trong-bi-vit-ny\"><span class=\"ez-toc-section\" id=\"Chung_ta_da_lam_gi_trong_bai_viet_nay\"><\/span>Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Qua b\u00e0i n\u00e0y, c\u00e1c b\u1ea1n \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c 1 s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 d\u00f9ng t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">LIKE<\/code> trong <code class=\"highlighter-rouge\">SQL<\/code> d\u00f9ng \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u r\u1ea5t hi\u1ec7u qu\u1ea3 d\u1ef1a tr\u00ean \u0111\u1eb7c \u0111i\u1ec3m c\u1ee7a d\u1eef li\u1ec7u. N\u1ebfu c\u00f3 c\u00e2u h\u1ecfi g\u00ec trong qu\u00e1 tr\u00ecnh \u0111\u1ecdc, h\u00e3y comment l\u1ea1i \u1edf d\u01b0\u1edbi :). Ch\u00e0o c\u00e1c b\u1ea1n t\u00e1c gi\u1ea3 xin ph\u00e9p \u0111i ng\u1ee7.<\/p>\n<p>Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/p>\n<p><a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\">Download excel file<\/a><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ex101_92019-nho-833.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8900,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8899","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=8899"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8899\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8900"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}