{"id":1761,"date":"2025-12-29T16:43:23","date_gmt":"2025-12-29T13:43:23","guid":{"rendered":"https:\/\/markahost.com.tr\/blog\/?p=1761"},"modified":"2025-12-29T16:43:23","modified_gmt":"2025-12-29T13:43:23","slug":"sql-like-nedir-kullanimi-nasildir-orneklerle-anlatim","status":"publish","type":"post","link":"https:\/\/markahost.com.tr\/blog\/sql-like-nedir-kullanimi-nasildir-orneklerle-anlatim\/","title":{"rendered":"SQL LIKE Nedir? Kullan\u0131m\u0131 Nas\u0131ld\u0131r? \u00d6rneklerle Anlat\u0131m"},"content":{"rendered":"<h2><strong>SQL LIKE Nedir?<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE ifadesi, SQL dilinde metin tabanl\u0131 alanlar \u00fczerinde arama ve filtreleme i\u015flemleri ger\u00e7ekle\u015ftirmek amac\u0131yla kullan\u0131lan operat\u00f6rd\u00fcr. Metin ifadelerinin \u00f6nceden tan\u0131mlanm\u0131\u015f desenlerle e\u015fle\u015fip e\u015fle\u015fmedi\u011fini tespit etmeye yarar. LIKE operat\u00f6r\u00fc, SQL sorgular\u0131nda \u00e7o\u011funlukla WHERE ko\u015fulu ile birlikte \u00e7al\u0131\u015f\u0131r.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bu operat\u00f6r, genellikle iki adet joker karakter ile kullan\u0131l\u0131r: \u201c%\u201d ve \u201c_\u201d.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u201c%\u201d sembol\u00fc, s\u0131f\u0131r veya daha fazla karakteri temsil eder.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0\u201c_\u201d sembol\u00fc, yaln\u0131zca tek karakteri temsil eder.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Bu joker karakterler yard\u0131m\u0131yla aranan metin desenine g\u00f6re sonu\u00e7lar s\u00fcz\u00fcl\u00fcr.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00d6rnek olarak; \u201cm%\u201d deseni kullan\u0131ld\u0131\u011f\u0131nda, veritaban\u0131nda \u201cm\u201d harfiyle ba\u015flayan t\u00fcm ifadeler listelenir. \u201c%a\u201d deseni, \u201ca\u201d harfiyle biten de\u011ferleri getirir. \u201ci_e\u201d deseni ise ilk harfi \u201ci\u201d, \u00fc\u00e7\u00fcnc\u00fc harfi \u201ce\u201d olan metinleri e\u015fle\u015ftirir.<\/span><\/p>\n<h2><strong>LIKE Operat\u00f6r\u00fc Ne \u0130\u015fe Yarar?<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fc, veritaban\u0131 tablolar\u0131nda yer alan s\u00fctunlar \u00fczerinde tan\u0131ml\u0131 desenlere g\u00f6re arama yap\u0131lmas\u0131n\u0131 sa\u011flar. K\u0131smi e\u015fle\u015fme ve desen bazl\u0131 sorgulama yap\u0131lmas\u0131na imk\u00e2n tan\u0131r. Metin i\u00e7erikli alanlar \u00fczerinde esnek filtreleme gereksinimi bulunan durumlarda yayg\u0131n \u015fekilde tercih edilir.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Wildcard karakterler ile birlikte kullan\u0131ld\u0131\u011f\u0131nda, sabit e\u015fle\u015fmelere ba\u011fl\u0131 kalmadan daha kapsaml\u0131 arama ko\u015fullar\u0131 olu\u015fturulabilir. Bu yap\u0131, \u00f6zellikle b\u00fcy\u00fck veri k\u00fcmeleri i\u00e7inde belirli kal\u0131plara uyan kay\u0131tlar\u0131n tespit edilmesini kolayla\u015ft\u0131r\u0131r.<\/span><\/p>\n<h2><strong>LIKE Operat\u00f6r\u00fcnde Kullan\u0131lan Wildcard Karakterleri<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">Wildcard karakterler, LIKE operat\u00f6r\u00fc ile birlikte kullan\u0131larak metinler i\u00e7erisinde desen e\u015fle\u015fmesi yap\u0131lmas\u0131n\u0131 sa\u011flar. Bu karakterler, metin i\u00e7inde yer alan karakterlerin yerini ge\u00e7ici olarak temsil eder. SQL dilinde kullan\u0131lan wildcard karakterleri a\u015fa\u011f\u0131da yer almaktad\u0131r:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">% (Percent): S\u0131f\u0131r veya daha fazla karakteri temsil eder.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">_ (Underscore): Tek karakteri temsil eder.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">[] (K\u00f6\u015feli Parantez): Parantez i\u00e7inde belirtilen karakterlerden herhangi birini temsil eder.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">\u00a0&#8211; (Tire): K\u00f6\u015feli parantez i\u00e7inde karakter aral\u0131\u011f\u0131 tan\u0131mlamak amac\u0131yla kullan\u0131l\u0131r.<\/span><\/li>\n<\/ul>\n<table>\n<tbody>\n<tr>\n<td><b>Pattern<\/b><\/td>\n<td><b>Anlam\u0131<\/b><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;a%&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u201ca\u201d harfiyle ba\u015flayan metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;%a&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u201ca\u201d harfiyle biten metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;a%t&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u201ca\u201d ile ba\u015flay\u0131p \u201ct\u201d ile biten metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;%wow%&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u201cwow\u201d ifadesini herhangi konumda i\u00e7eren metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;_wow%&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u201cwow\u201d ifadesi ikinci karakterden ba\u015flayan metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;_a%&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u0130kinci karakteri \u201ca\u201d olan metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<tr>\n<td><span style=\"font-weight: 400;\">&#8216;a__%&#8217;<\/span><\/td>\n<td><span style=\"font-weight: 400;\">\u201ca\u201d harfiyle ba\u015flayan ve en az iki ek karakter i\u00e7eren metinleri e\u015fle\u015ftirir<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2><strong>SQL LIKE Temel Kullan\u0131m S\u00f6z Dizimi<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fc, SQL sorgular\u0131nda genellikle WHERE ko\u015fulu i\u00e7erisinde kullan\u0131l\u0131r ve s\u00fctun verilerinin tan\u0131mlanan desenle uyumunu kontrol eder. Wildcard karakterler yard\u0131m\u0131yla esnek arama yap\u0131s\u0131 olu\u015fturulur. Temel kullan\u0131m s\u00f6z dizimi a\u015fa\u011f\u0131da g\u00f6sterilmektedir:<\/span><\/p>\n<p><b>SELECT <\/b><span style=\"font-weight: 400;\">column_name(s)<\/span><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">table_name<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">column_name LIKE pattern;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Desenle e\u015fle\u015fmeyen kay\u0131tlar\u0131n listelenmesi amac\u0131yla NOT ifadesi ile birlikte kullan\u0131m m\u00fcmk\u00fcnd\u00fcr:<\/span><\/p>\n<p><b>SELECT <\/b><span style=\"font-weight: 400;\">column_name(s)<\/span><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">table_name<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">column_name NOT LIKE pattern;<\/span><\/p>\n<h2><strong>LIKE ile S\u0131k Kullan\u0131lan Arama \u00d6rnekleri<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fcn\u00fcn yayg\u0131n kullan\u0131m senaryolar\u0131 a\u015fa\u011f\u0131daki \u00f6rnekler \u00fczerinden a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n<ol>\n<li><b> Belirli Karakterle Ba\u015flayan Verileri Listelemek<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">LIKE ifadesi kullan\u0131larak, belirli karakter ile ba\u015flayan kay\u0131tlar filtrelenebilir. \u00d6rnek olarak, \u201cisim\u201d alan\u0131nda \u201cA\u201d harfiyle ba\u015flayan t\u00fcm kay\u0131tlar\u0131 getirmek amac\u0131yla a\u015fa\u011f\u0131daki sorgu kullan\u0131labilir:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">SELECT * FROM tablo WHERE isim LIKE &#8216;A%&#8217;;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bu sorgu sonucunda, \u201cisim\u201d s\u00fctununda de\u011feri \u201cA\u201d harfiyle ba\u015flayan t\u00fcm kay\u0131tlar listelenir.<\/span><\/p>\n<ol start=\"2\">\n<li><b> Belirli Karakterle Biten Verileri Listelemek<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fc yard\u0131m\u0131yla, belirli karakter ile sonlanan veriler tespit edilebilir. \u00d6rnek olarak, \u201cisim\u201d alan\u0131nda \u201cB\u201d harfiyle biten kay\u0131tlar a\u015fa\u011f\u0131daki sorgu ile elde edilir:<\/span><\/p>\n<p><b>SELECT <\/b><span style=\"font-weight: 400;\">* <\/span><b>FROM <\/b><span style=\"font-weight: 400;\">tablo <\/span><b>WHERE <\/b><span style=\"font-weight: 400;\">isim LIKE &#8216;%B&#8217;;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bu sorgu, \u201cisim\u201d s\u00fctununda \u201cB\u201d harfiyle biti\u015f yapan t\u00fcm de\u011ferleri d\u00f6nd\u00fcr\u00fcr.<\/span><\/p>\n<ol start=\"3\">\n<li><b> Belirli Desene Uyan Verileri Filtrelemek<\/b><\/li>\n<\/ol>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fc, ba\u015flang\u0131\u00e7 ve biti\u015f ko\u015fullar\u0131 tan\u0131mlanm\u0131\u015f desenlere g\u00f6re filtreleme yap\u0131lmas\u0131na imk\u00e2n tan\u0131r. \u201cisim\u201d alan\u0131nda \u201cA\u201d harfiyle ba\u015flay\u0131p \u201cB\u201d harfiyle sonlanan kay\u0131tlar i\u00e7in a\u015fa\u011f\u0131daki sorgu kullan\u0131labilir:<\/span><\/p>\n<p><b>SELECT <\/b><span style=\"font-weight: 400;\">* <\/span><b>FROM <\/b><span style=\"font-weight: 400;\">tablo <\/span><b>WHERE <\/b><span style=\"font-weight: 400;\">isim <\/span><b>LIKE <\/b><span style=\"font-weight: 400;\">&#8216;A%B&#8217;;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bu yap\u0131 sayesinde, belirtilen desenle uyumlu t\u00fcm kay\u0131tlar sonu\u00e7 k\u00fcmesine dahil edilir.<\/span><\/p>\n<h2><strong>B\u00fcy\u00fck\/K\u00fc\u00e7\u00fck Harf Duyarl\u0131l\u0131\u011f\u0131 (Case Sensitivity) Konusu<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fcn\u00fcn b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131l\u0131\u011f\u0131, kullan\u0131lan veritaban\u0131 sistemi ve ilgili yap\u0131land\u0131rmaya g\u00f6re farkl\u0131l\u0131k g\u00f6sterebilir. Redshift, BigQuery ve Snowflake platformlar\u0131nda davran\u0131\u015f bi\u00e7imleri a\u015fa\u011f\u0131daki gibidir:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Redshift:<\/b><span style=\"font-weight: 400;\"> Varsay\u0131lan ayarlarda LIKE operat\u00f6r\u00fc b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131 \u00e7al\u0131\u015f\u0131r. B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf ayr\u0131m\u0131 yap\u0131lmayan aramalar i\u00e7in LIKE yerine ILIKE ifadesi tercih edilir.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>BigQuery:<\/b><span style=\"font-weight: 400;\"> LIKE operat\u00f6r\u00fc b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131d\u0131r. Harf duyarl\u0131l\u0131\u011f\u0131 olmadan arama yap\u0131lmas\u0131 istendi\u011finde, d\u00fczenli ifadelerle \u00e7al\u0131\u015fan REGEXP_CONTAINS fonksiyonu kullan\u0131l\u0131r.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><b>Snowflake:<\/b><span style=\"font-weight: 400;\"> LIKE operat\u00f6r\u00fcn\u00fcn davran\u0131\u015f\u0131, ilgili s\u00fctunun s\u0131ralama d\u00fczenine ba\u011fl\u0131d\u0131r. Varsay\u0131lan s\u0131ralama d\u00fczeni b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyars\u0131z oldu\u011fu i\u00e7in LIKE ifadesi de duyars\u0131z \u00e7al\u0131\u015f\u0131r. Ancak s\u00fctun, harf duyarl\u0131l\u0131\u011f\u0131 i\u00e7eren s\u0131ralama d\u00fczenine sahipse, LIKE operat\u00f6r\u00fc de duyarl\u0131 \u015fekilde i\u015flem yapar. S\u0131ralama d\u00fczeninden ba\u011f\u0131ms\u0131z olarak, a\u00e7\u0131k bi\u00e7imde duyars\u0131z arama yap\u0131lmas\u0131 amac\u0131yla ILIKE operat\u00f6r\u00fc kullan\u0131labilir.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Kullan\u0131lan veritaban\u0131 platformuna ait resmi dok\u00fcmantasyonun incelenmesi, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf davran\u0131\u015f\u0131n\u0131n do\u011fru \u015fekilde anla\u015f\u0131lmas\u0131 a\u00e7\u0131s\u0131ndan \u00f6nem ta\u015f\u0131r.<\/span><\/p>\n<h2><strong>NOT LIKE Kullan\u0131m\u0131 ve \u00d6rnekleri<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fcn\u00fcn \u00e7al\u0131\u015fma mant\u0131\u011f\u0131, NOT ifadesi ile tersine \u00e7evrilebilir. Bu kullan\u0131m, belirtilen desenle e\u015fle\u015fmeyen kay\u0131tlar\u0131n se\u00e7ilmesini sa\u011flar.<\/span><\/p>\n<p><b>Syntax<\/b><\/p>\n<p><b>SELECT <\/b><span style=\"font-weight: 400;\">column1, column2, &#8230;<\/span><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">table_name<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">column <\/span><b>NOT LIKE <\/b><span style=\"font-weight: 400;\">value;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Bu yap\u0131 i\u00e7erisinde:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">column1, column2, &#8230;: Se\u00e7ilecek s\u00fctunlar\u0131 ifade eder<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">table_name: Veri kayna\u011f\u0131 olan tablo ad\u0131n\u0131 belirtir<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">column: Filtre uygulanacak s\u00fctunu g\u00f6sterir<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">NOT LIKE: Belirtilen desenle e\u015fle\u015fen kay\u0131tlar\u0131 hari\u00e7 tutar<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">value: E\u015fle\u015fmesi istenmeyen desen bilgisini temsil eder<\/span><\/li>\n<\/ul>\n<p><b>\u00d6rnek Kullan\u0131m<\/b><\/p>\n<p><span style=\"font-weight: 400;\">A\u015fa\u011f\u0131daki sorgu, \u00fclkesi \u201cUSA\u201d olmayan t\u00fcm m\u00fc\u015fterileri listeler:<\/span><\/p>\n<p><b>SELECT *<\/b><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">Customers<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">country <\/span><b>NOT LIKE<\/b><span style=\"font-weight: 400;\"> &#8216;USA&#8217;;<\/span><\/p>\n<h2><strong>LIKE ile \u00c7oklu \u015eart Kullan\u0131m\u0131 (AND \u2013 OR)<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE operat\u00f6r\u00fc, AND ve OR mant\u0131ksal operat\u00f6rleri ile birlikte kullan\u0131larak daha karma\u015f\u0131k desen e\u015fle\u015ftirme ko\u015fullar\u0131 olu\u015fturulmas\u0131na imk\u00e2n tan\u0131r. Bu yakla\u015f\u0131m, sorgu sonu\u00e7lar\u0131n\u0131 geni\u015fletmek veya daraltmak amac\u0131yla tercih edilir.<\/span><\/p>\n<p><b>LIKE ile OR Operat\u00f6r\u00fcn\u00fcn Birlikte Kullan\u0131m\u0131<\/b><\/p>\n<p><span style=\"font-weight: 400;\">OR operat\u00f6r\u00fc, tan\u0131mlanan ko\u015fullardan en az uyum sa\u011flayan kay\u0131tlar\u0131n getirilmesini sa\u011flar. Farkl\u0131 desenlere uyan de\u011ferlerin ayn\u0131 sorgu i\u00e7erisinde aranmas\u0131 gerekti\u011finde kullan\u0131\u015fl\u0131d\u0131r.<\/span><\/p>\n<p><b>SELECT <\/b><span style=\"font-weight: 400;\">column1, column2<\/span><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">table_name<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">column_name LIKE &#8216;pattern1&#8217;<\/span><\/p>\n<p><b>OR <\/b><span style=\"font-weight: 400;\">column_name LIKE &#8216;pattern2&#8217;<\/span><\/p>\n<p><b>OR <\/b><span style=\"font-weight: 400;\">column_name LIKE &#8216;pattern3&#8217;;<\/span><\/p>\n<p><b>\u00d6rnek:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Ad\u0131 \u201cS\u201d ya da \u201cA\u201d harfiyle ba\u015flayan t\u00fcm m\u00fc\u015fterileri listeleyen sorgu a\u015fa\u011f\u0131da yer almaktad\u0131r:<\/span><\/p>\n<p><b>SELECT *<\/b><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">Customers<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">CustomerName LIKE &#8216;S%&#8217; OR CustomerName LIKE &#8216;A%&#8217;;<\/span><\/p>\n<p><b>LIKE ile AND Operat\u00f6r\u00fcn\u00fcn Birlikte Kullan\u0131m\u0131<\/b><\/p>\n<p><span style=\"font-weight: 400;\">AND operat\u00f6r\u00fc, belirtilen ko\u015fullar\u0131n <\/span><b>tamam\u0131n\u0131<\/b><span style=\"font-weight: 400;\"> kar\u015f\u0131layan kay\u0131tlar\u0131n se\u00e7ilmesini sa\u011flar. \u00c7oklu kriter \u00fczerinden daha dar sonu\u00e7 k\u00fcmesi elde edilmesi hedeflendi\u011finde kullan\u0131l\u0131r.<\/span><\/p>\n<p><b>SELECT<\/b><span style=\"font-weight: 400;\"> column1, column2<\/span><\/p>\n<p><b>FROM <\/b><span style=\"font-weight: 400;\">table_name<\/span><\/p>\n<p><b>WHERE <\/b><span style=\"font-weight: 400;\">column_name LIKE &#8216;pattern1&#8217;<\/span><\/p>\n<p><b>AND <\/b><span style=\"font-weight: 400;\">other_column LIKE &#8216;pattern2&#8217;;<\/span><\/p>\n<p><b>\u00d6rnek:<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Ad\u0131 \u201cS\u201d harfiyle ba\u015flayan ve \u015fehir ad\u0131 \u201cL\u201d harfiyle ba\u015flayan t\u00fcm m\u00fc\u015fterileri getiren sorgu a\u015fa\u011f\u0131da g\u00f6sterilmektedir:<\/span><\/p>\n<p><b>SELECT *<\/b><\/p>\n<p><b>FROM<\/b><span style=\"font-weight: 400;\"> Customers<\/span><\/p>\n<p><b>WHERE<\/b><span style=\"font-weight: 400;\"> CustomerName LIKE &#8216;S%&#8217; AND City LIKE &#8216;L%&#8217;;<\/span><\/p>\n<h2><strong>LIKE Kullan\u0131rken Performans Sorunlar\u0131 ve \u0130pu\u00e7lar\u0131<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">Veritaban\u0131 sorgular\u0131nda performans optimizasyonu, yan\u0131t s\u00fcrelerinin k\u0131salt\u0131lmas\u0131 ve kaynak kullan\u0131m\u0131n\u0131n azalt\u0131lmas\u0131 a\u00e7\u0131s\u0131ndan kritik \u00f6nem ta\u015f\u0131r. LIKE operat\u00f6r\u00fc kullan\u0131lan sorgularda s\u0131k kar\u015f\u0131la\u015f\u0131lan hatal\u0131 yakla\u015f\u0131mlar ve tercih edilmesi gereken y\u00f6ntemler a\u015fa\u011f\u0131da a\u00e7\u0131klanmaktad\u0131r.<\/span><\/p>\n<p><b>Hatal\u0131 Kullan\u0131m 1: SELECT * \u0130fadesinin Tercih Edilmesi<\/b><\/p>\n<p><span style=\"font-weight: 400;\">SELECT * kullan\u0131m\u0131, tablo i\u00e7indeki t\u00fcm s\u00fctunlar\u0131n okunmas\u0131na neden olur. B\u00fcy\u00fck tablolar \u00fczerinde \u00e7al\u0131\u015f\u0131ld\u0131\u011f\u0131nda, gereksiz veri okunmas\u0131 performans sorunlar\u0131na yol a\u00e7ar.<\/span><\/p>\n<p><b>Do\u011fru Yakla\u015f\u0131m: Gerekli S\u00fctunlar\u0131n Se\u00e7ilmesi<\/b><\/p>\n<p><span style=\"font-weight: 400;\">SELECT * yerine, sorguda ihtiya\u00e7 duyulan s\u00fctun adlar\u0131n\u0131n a\u00e7\u0131k \u015fekilde belirtilmesi \u00f6nerilir. Bu y\u00f6ntem, okunan veri miktar\u0131n\u0131 azaltarak sorgu performans\u0131n\u0131 iyile\u015ftirir.<\/span><\/p>\n<p><b>Hatal\u0131 Kullan\u0131m 2: SELECT \u0130\u00e7erisinde Alt Sorgu Kullan\u0131m\u0131<\/b><\/p>\n<p><span style=\"font-weight: 400;\">SELECT ifadesi i\u00e7inde yer alan alt sorgular, \u00f6zellikle sonu\u00e7 say\u0131s\u0131 y\u00fcksek oldu\u011funda maliyetli i\u015flemler olu\u015fturur. Bu durum, sorgu s\u00fcresinin uzamas\u0131na neden olur.<\/span><\/p>\n<p><b>Do\u011fru Yakla\u015f\u0131m: Alt Sorgu Yerine JOIN Kullan\u0131m\u0131<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Alt sorgular yerine JOIN yap\u0131lar\u0131n\u0131n tercih edilmesi, veritaban\u0131 motorunun sorguyu daha verimli optimize etmesine olanak tan\u0131r. JOIN kullan\u0131m\u0131, \u00e7oklu tablo verilerinin daha h\u0131zl\u0131 \u015fekilde birle\u015ftirilmesini sa\u011flar.<\/span><\/p>\n<p><b>Hatal\u0131 Kullan\u0131m 3: LIKE ile Ba\u015fta Joker Karakter Kullan\u0131m\u0131<\/b><\/p>\n<p><span style=\"font-weight: 400;\">LIKE ifadesinde desenin ba\u015f\u0131nda % kullan\u0131lmas\u0131, indekslerin devre d\u0131\u015f\u0131 kalmas\u0131na neden olur. Bu durum, tablo genelinde tarama yap\u0131lmas\u0131na yol a\u00e7ar ve performans\u0131 olumsuz etkiler.<\/span><\/p>\n<p><b>Do\u011fru Yakla\u015f\u0131m: \u0130ndeks Kullan\u0131m\u0131 ve Sonda Joker Karakter Tercihi<\/b><\/p>\n<p><span style=\"font-weight: 400;\">Metin alanlar\u0131 \u00fczerinde arama yap\u0131l\u0131rken, indekslerin etkin \u015fekilde kullan\u0131labilmesi i\u00e7in joker karakterin desenin sonunda yer almas\u0131 \u00f6nerilir. Bu yakla\u015f\u0131m, tam tablo taramas\u0131 yerine indeks destekli arama yap\u0131lmas\u0131n\u0131 sa\u011flar ve sorgu s\u00fcresini d\u00fc\u015f\u00fcr\u00fcr.<\/span><\/p>\n<h2><strong>LIKE vs. ILIKE (PostgreSQL) \u2013 Farklar\u0131<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">LIKE ve ILIKE operat\u00f6rleri aras\u0131ndaki tercih, sorgu gereksinimine ve kullan\u0131m amac\u0131na g\u00f6re \u015fekillenir. B\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf duyarl\u0131 desen e\u015fle\u015ftirmesi gerekti\u011finde LIKE operat\u00f6r\u00fc, harf duyarl\u0131l\u0131\u011f\u0131 olmadan e\u015fle\u015ftirme yap\u0131lmas\u0131 istendi\u011finde ise ILIKE operat\u00f6r\u00fc tercih edilir. Ancak se\u00e7im a\u015famas\u0131nda de\u011ferlendirilmesi gereken baz\u0131 \u00f6nemli noktalar bulunmaktad\u0131r:<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><b>Performans:<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">ILIKE operat\u00f6r\u00fc, kar\u015f\u0131la\u015ft\u0131rma i\u015fleminden \u00f6nce metin ve desen \u00fczerinde ek b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf d\u00f6n\u00fc\u015ft\u00fcrme s\u00fcreci y\u00fcr\u00fctt\u00fc\u011f\u00fc i\u00e7in LIKE operat\u00f6r\u00fcne k\u0131yasla daha d\u00fc\u015f\u00fck performans g\u00f6sterebilir. Veri hacmi y\u00fcksek sorgular veya h\u0131z optimizasyonu gerektiren senaryolarda LIKE operat\u00f6r\u00fc tercih edilerek daha verimli sonu\u00e7lar elde edilebilir.<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><b>Ta\u015f\u0131nabilirlik:<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">ILIKE operat\u00f6r\u00fc PostgreSQL sistemine \u00f6zg\u00fc uzant\u0131 niteli\u011fi ta\u015f\u0131r ve farkl\u0131 veritaban\u0131 motorlar\u0131nda desteklenmeyebilir. \u00c7oklu platform uyumlulu\u011fu hedeflenen SQL ifadelerinde, LIKE operat\u00f6r\u00fc ile birlikte UPPER veya LOWER fonksiyonlar\u0131n\u0131n kullan\u0131lmas\u0131 \u00f6nerilir. Bu yakla\u015f\u0131m sayesinde, ILIKE ile elde edilen sonu\u00e7lar standart SQL s\u00f6z dizimi kullan\u0131larak \u00fcretilebilir.<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><b>Tutarl\u0131l\u0131k:<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">ILIKE operat\u00f6r\u00fcn\u00fcn \u00fcretti\u011fi sonu\u00e7lar, veritaban\u0131n\u0131n yerel ayar yap\u0131land\u0131rmas\u0131na ba\u011fl\u0131 olarak de\u011fi\u015fkenlik g\u00f6sterebilir. Yerel ayar, b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf d\u00f6n\u00fc\u015f\u00fcm kurallar\u0131n\u0131 belirler ve sistemler aras\u0131nda farkl\u0131l\u0131k g\u00f6sterebilir. \u00d6rnek olarak, Almanca dilinde yer alan \u201c\u00df\u201d ve \u201cSS\u201d gibi karakterler bu duruma etki edebilir. Tutarl\u0131 ve \u00f6ng\u00f6r\u00fclebilir e\u015fle\u015fme sonu\u00e7lar\u0131 hedefleniyorsa, LIKE operat\u00f6r\u00fc kullan\u0131larak metin ve desenin a\u00e7\u0131k b\u00fcy\u00fck\/k\u00fc\u00e7\u00fck harf durumu tan\u0131mlanmal\u0131d\u0131r.<\/span><\/p>\n<h2><strong>SQL\u2019de LIKE Yerine Kullan\u0131labilecek Alternatifler<\/strong><\/h2>\n<p><span style=\"font-weight: 400;\">SQL ortamlar\u0131nda desen e\u015fle\u015ftirme ve metin arama i\u015flemleri i\u00e7in LIKE operat\u00f6r\u00fcne ek olarak farkl\u0131 y\u00f6ntemler de kullan\u0131labilir. Bu alternatifler, kullan\u0131lan veritaban\u0131 sistemi ve sorgu gereksinimine ba\u011fl\u0131 olarak daha y\u00fcksek performans veya daha esnek arama imk\u00e2n\u0131 sunabilir.<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><b>Exact Matching (Tam E\u015fle\u015fme)<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Wildcard kullan\u0131lmayan kesin metin kar\u015f\u0131la\u015ft\u0131rmalar\u0131 i\u00e7in e\u015fitlik operat\u00f6r\u00fc (=) tercih edilebilir. Bu y\u00f6ntem, desen taramas\u0131 gerektirmedi\u011fi i\u00e7in indeksler \u00fczerinde daha h\u0131zl\u0131 \u00e7al\u0131\u015f\u0131r ve do\u011frudan e\u015fle\u015fme senaryolar\u0131nda performans avantaj\u0131 sa\u011flar.<\/span><\/p>\n<ul>\n<li aria-level=\"1\"><b>String Fonksiyonlar\u0131<\/b><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">INSTR, CHARINDEX veya POSITION gibi metin fonksiyonlar\u0131, belirli alt ifadelerin konumunu tespit etmek amac\u0131yla kullan\u0131l\u0131r. Bu fonksiyonlar, \u00f6zellikle LIKE &#8216;%ifade%&#8217; yap\u0131s\u0131n\u0131n kullan\u0131ld\u0131\u011f\u0131 basit senaryolarda alternatif \u00e7\u00f6z\u00fcm olarak de\u011ferlendirilebilir ve baz\u0131 durumlarda daha kontroll\u00fc sonu\u00e7lar \u00fcretir.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL LIKE Nedir? LIKE ifadesi, SQL dilinde metin tabanl\u0131 alanlar \u00fczerinde arama ve filtreleme i\u015flemleri ger\u00e7ekle\u015ftirmek amac\u0131yla kullan\u0131lan operat\u00f6rd\u00fcr. Metin<\/p>\n","protected":false},"author":2,"featured_media":1762,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"rank_math_lock_modified_date":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1761","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-genel"],"_links":{"self":[{"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/posts\/1761","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=1761"}],"version-history":[{"count":1,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/posts\/1761\/revisions"}],"predecessor-version":[{"id":1763,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/posts\/1761\/revisions\/1763"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/media\/1762"}],"wp:attachment":[{"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=1761"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=1761"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/markahost.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=1761"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}