{"id":507,"date":"2017-03-18T20:20:19","date_gmt":"2017-03-18T18:20:19","guid":{"rendered":"http:\/\/fatihsoysal.com\/blog\/?p=507"},"modified":"2018-02-09T21:47:46","modified_gmt":"2018-02-09T19:47:46","slug":"mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like","status":"publish","type":"post","link":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/","title":{"rendered":"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}"},"content":{"rendered":"<blockquote><p>Merhaba herkese. Bu yaz\u0131mda MySQL sorgular\u0131nda s\u0131k\u00e7a ortaya \u00e7\u0131kan bir problemden bahsetmek istiyorum sizlere.<\/p><\/blockquote>\n<p>Normal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen bir durumdur. Bunu \u00e7\u00f6zmenin bir\u00e7ok yolu var. Arama k\u0131sm\u0131ndan al\u0131nan verinin s\u00fcz\u00fcl\u00fcp query i\u00e7erisine yans\u0131t\u0131lmas\u0131 bunlardan biri \u00f6rne\u011fin. Ama iyi bir veritaban\u0131 yap\u0131s\u0131 developer&#8217;a her zaman en az i\u015f y\u00fck\u00fcn\u00fc do\u011furand\u0131r. Yani kod taraf\u0131nda extra bir \u00e7al\u0131\u015fma yapmadan bu i\u015flemi ger\u00e7ekle\u015ftirmek m\u00fcmk\u00fcn. Nas\u0131l m\u0131? \u00d6rne\u011fin bir \u00f6rnek \u00fczerinden gidelim.<\/p>\n<pre class=\"lang:default decode:true \">SELECT * FROM trees WHERE trees.`title` LIKE  '%elm%'<\/pre>\n<p>Yukar\u0131da g\u00f6rm\u00fc\u015f oldu\u011funuz sorgu MySQL 5 \u00fczerinde sadece k\u00fc\u00e7\u00fck harf duyarl\u0131 \u00e7al\u0131\u015f\u0131r. Yani tablo \u00fczerinde &#8216;Elma&#8217; yada &#8216;ELMA&#8217; varsa bunlar\u0131 yakalamaz.<\/p>\n<p><strong>\u00c7\u00f6z\u00fcm<\/strong><\/p>\n<pre class=\"lang:default decode:true \">SELECT  *\r\nFROM    trees\r\nWHERE   trees.`title` COLLATE UTF8_GENERAL_CI LIKE '%elm%'<\/pre>\n<p>Asl\u0131nda, tablo s\u00fctun tan\u0131m\u0131na <strong>COLLATE UTF8_GENERAL_CI<\/strong> eklerseniz, i\u015flem\u00a0otomatik olarak istedi\u011fimiz d\u00fczeyde \u00e7al\u0131\u015f\u0131r. Tabi tablo karakter kodlaman\u0131z UTF-8 olmal\u0131d\u0131r. De\u011fil ise a\u015fa\u011f\u0131daki sorgu yard\u0131m\u0131yla h\u0131zl\u0131ca g\u00fcncelleyebilirsiniz.<\/p>\n<pre class=\"lang:default decode:true \">ALTER TABLE trees \r\n MODIFY COLUMN title VARCHAR(\u2026) CHARACTER \r\n SET UTF8 COLLATE UTF8_GENERAL_CI.<\/pre>\n<p>Not: Bu i\u015flem tablo s\u00fctun dizinlerini yeniden olu\u015fturacak. Bundan dolay\u0131 i\u015flem \u00f6ncesinde veritaban\u0131 yede\u011fi alman\u0131z\u0131 tavsiye ederim.<\/p>\n<p><strong>Y\u00f6ntem 2 (Bonus)<\/strong><\/p>\n<pre class=\"lang:default decode:true \">SELECT * FROM &lt;trees&gt; WHERE LOWER(&lt;title&gt;) LIKE LOWER('%&lt;elm&gt;%')<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"Merhaba herkese. Bu yaz\u0131mda MySQL sorgular\u0131nda s\u0131k\u00e7a ortaya \u00e7\u0131kan bir problemden bahsetmek istiyorum sizlere. Normal olarak sorgu i\u00e7erisinde&hellip;","protected":false},"author":1,"featured_media":514,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"csco_page_header_type":"","csco_page_load_nextpost":"","csco_page_subscribe_form":"","csco_page_contact_form":"","footnotes":""},"categories":[138,121,10],"tags":[146,147,148,149],"class_list":{"0":"post-507","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-mysql","8":"category-sql","9":"category-yazilim","10":"tag-mysql-buyuk-kucuk-harf","11":"tag-mysql-duyarli-like","12":"tag-mysql-duyarsiz-like","13":"tag-mysql-tukce-karakter","14":"cs-entry","15":"cs-video-wrap"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.5 (Yoast SEO v25.3.1) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE} - Kodlar\u0131n Gizemli D\u00fcnyas\u0131<\/title>\n<meta name=\"description\" content=\"ormal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\" \/>\n<meta property=\"og:locale\" content=\"tr_TR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}\" \/>\n<meta property=\"og:description\" content=\"ormal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen\" \/>\n<meta property=\"og:url\" content=\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\" \/>\n<meta property=\"og:site_name\" content=\"Kodlar\u0131n Gizemli D\u00fcnyas\u0131\" \/>\n<meta property=\"article:published_time\" content=\"2017-03-18T18:20:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-09T19:47:46+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1980\" \/>\n\t<meta property=\"og:image:height\" content=\"1150\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Fatih Soysal\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Yazan:\" \/>\n\t<meta name=\"twitter:data1\" content=\"Fatih Soysal\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tahmini okuma s\u00fcresi\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 dakika\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\"},\"author\":{\"name\":\"Fatih Soysal\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"headline\":\"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}\",\"datePublished\":\"2017-03-18T18:20:19+00:00\",\"dateModified\":\"2018-02-09T19:47:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\"},\"wordCount\":233,\"commentCount\":1,\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg\",\"keywords\":[\"mysql b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf\",\"mysql duyarl\u0131 like\",\"mysql duyars\u0131z like\",\"mysql t\u00fck\u00e7e karakter\"],\"articleSection\":[\"MySQL\",\"SQL\",\"Yaz\u0131l\u0131m\"],\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#respond\"]}],\"copyrightYear\":\"2017\",\"copyrightHolder\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\",\"name\":\"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE} - Kodlar\u0131n Gizemli D\u00fcnyas\u0131\",\"isPartOf\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg\",\"datePublished\":\"2017-03-18T18:20:19+00:00\",\"dateModified\":\"2018-02-09T19:47:46+00:00\",\"description\":\"ormal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen\",\"breadcrumb\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#breadcrumb\"},\"inLanguage\":\"tr\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg\",\"width\":1980,\"height\":1150},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Anasayfa\",\"item\":\"https:\/\/fatihsoysal.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#website\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/\",\"name\":\"Fatihsoysal.com\",\"description\":\"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim\",\"publisher\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"tr\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1\",\"name\":\"Fatih Soysal\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"tr\",\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"contentUrl\":\"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png\",\"width\":512,\"height\":512,\"caption\":\"Fatih Soysal\"},\"logo\":{\"@id\":\"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.\",\"url\":\"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE} - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","description":"ormal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen","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:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/","og_locale":"tr_TR","og_type":"article","og_title":"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}","og_description":"ormal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen","og_url":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/","og_site_name":"Kodlar\u0131n Gizemli D\u00fcnyas\u0131","article_published_time":"2017-03-18T18:20:19+00:00","article_modified_time":"2018-02-09T19:47:46+00:00","og_image":[{"width":1980,"height":1150,"url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg","type":"image\/jpeg"}],"author":"Fatih Soysal","twitter_card":"summary_large_image","twitter_misc":{"Yazan:":"Fatih Soysal","Tahmini okuma s\u00fcresi":"1 dakika"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#article","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/"},"author":{"name":"Fatih Soysal","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"headline":"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}","datePublished":"2017-03-18T18:20:19+00:00","dateModified":"2018-02-09T19:47:46+00:00","mainEntityOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/"},"wordCount":233,"commentCount":1,"publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg","keywords":["mysql b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf","mysql duyarl\u0131 like","mysql duyars\u0131z like","mysql t\u00fck\u00e7e karakter"],"articleSection":["MySQL","SQL","Yaz\u0131l\u0131m"],"inLanguage":"tr","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#respond"]}],"copyrightYear":"2017","copyrightHolder":{"@id":"https:\/\/fatihsoysal.com\/blog\/#organization"}},{"@type":"WebPage","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/","url":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/","name":"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE} - Kodlar\u0131n Gizemli D\u00fcnyas\u0131","isPartOf":{"@id":"https:\/\/fatihsoysal.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage"},"image":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage"},"thumbnailUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg","datePublished":"2017-03-18T18:20:19+00:00","dateModified":"2018-02-09T19:47:46+00:00","description":"ormal olarak sorgu i\u00e7erisinde kulland\u0131\u011f\u0131n\u0131z LIKE komutu MySQL veritabanlar\u0131nda b\u00fcy\u00fck k\u00fc\u00e7\u00fck harf duyarl\u0131 vaziyettedir. Bu da kullan\u0131c\u0131 taraf\u0131nda istenmeyen","breadcrumb":{"@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#breadcrumb"},"inLanguage":"tr","potentialAction":[{"@type":"ReadAction","target":["https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/"]}]},{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#primaryimage","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2017\/03\/1-4aK5NNQb3DissjPYfl4_mA.jpg","width":1980,"height":1150},{"@type":"BreadcrumbList","@id":"https:\/\/fatihsoysal.com\/blog\/mysql-buyuk-kucuk-harf-duyarsiz-arama-islemi-like\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Anasayfa","item":"https:\/\/fatihsoysal.com\/blog\/"},{"@type":"ListItem","position":2,"name":"MySQL B\u00fcy\u00fck K\u00fc\u00e7\u00fck Harf Duyars\u0131z Arama \u0130\u015flemi {LIKE}"}]},{"@type":"WebSite","@id":"https:\/\/fatihsoysal.com\/blog\/#website","url":"https:\/\/fatihsoysal.com\/blog\/","name":"Fatihsoysal.com","description":"Blog - Yaz\u0131l\u0131m D\u00fcnyas\u0131 Tecr\u00fcbelerim","publisher":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/fatihsoysal.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"tr"},{"@type":["Person","Organization"],"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/002a254750921dcfd568a99e48240dd1","name":"Fatih Soysal","image":{"@type":"ImageObject","inLanguage":"tr","@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","contentUrl":"https:\/\/fatihsoysal.com\/blog\/wp-content\/uploads\/2024\/04\/cropped-replicate-prediction-3kgg1hgjn5rgp0cf0p5tr0jw7w-1.png","width":512,"height":512,"caption":"Fatih Soysal"},"logo":{"@id":"https:\/\/fatihsoysal.com\/blog\/#\/schema\/person\/image\/"},"description":"Kullan\u0131m ve kodlama m\u00fckemmeliyetini odak alan uygulamalar olu\u015fturma deneyimine sahip, profesyonel olarak 15+ y\u0131l \u00fczeri deneyime sahip bir yaz\u0131l\u0131m m\u00fchendisi.","url":"https:\/\/fatihsoysal.com\/blog\/author\/fatihsoysal\/"}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/507","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/comments?post=507"}],"version-history":[{"count":3,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/507\/revisions"}],"predecessor-version":[{"id":511,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/posts\/507\/revisions\/511"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media\/514"}],"wp:attachment":[{"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/media?parent=507"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/categories?post=507"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/fatihsoysal.com\/blog\/wp-json\/wp\/v2\/tags?post=507"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}