{"id":919,"date":"2020-02-10T21:11:28","date_gmt":"2020-02-10T18:11:28","guid":{"rendered":"http:\/\/www.aydiner.gen.tr\/?p=919"},"modified":"2023-04-23T20:33:57","modified_gmt":"2023-04-23T17:33:57","slug":"sql-select-deyimi-ile-verilerin-sorgulanmasi","status":"publish","type":"post","link":"https:\/\/www.aydiner.gen.tr\/index.php\/2020\/02\/10\/sql-select-deyimi-ile-verilerin-sorgulanmasi\/","title":{"rendered":"Sql Select Deyimi ile Verilerin Sorgulanmas\u0131"},"content":{"rendered":"<p><a href=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2020\/01\/sql.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft  wp-image-903\" src=\"https:\/\/www.aydiner.gen.tr\/wp-content\/uploads\/2020\/01\/sql-300x243.png\" alt=\"\" width=\"147\" height=\"119\" \/><\/a>Select ifadesi, herhangi bir veritaban\u0131 i\u00e7erisinde ki verileri sorgulamak i\u00e7in kullan\u0131lan en basit ayn\u0131 zamanda en kapsaml\u0131 komuttur. Bu yaz\u0131mda basitten karma\u015f\u0131\u011fa do\u011fru select komutu kullan\u0131m\u0131n\u0131 \u00f6rneklerle anlatmaya \u00e7al\u0131\u015faca\u011f\u0131m. Konunun daha iyi anla\u015f\u0131lmas\u0131 i\u00e7in a\u015fa\u011f\u0131daki \u00f6rnek\u00a0<strong>musteriler\u00a0<\/strong>tablosunu kullanarak sorgulama i\u015flemlerini ger\u00e7ekle\u015ftirece\u011fiz.<\/p>\n<p><!--more--><\/p>\n<blockquote class=\"wp-embedded-content\" data-secret=\"Mqc1R5qM5X\"><p><a href=\"https:\/\/www.kodlamamerkezi.com\/\">Anasayfa<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; visibility: hidden;\" title=\"&#8220;Anasayfa&#8221; &#8212; Kodlama Merkezi\" src=\"https:\/\/www.kodlamamerkezi.com\/embed\/#?secret=Mqc1R5qM5X\" data-secret=\"Mqc1R5qM5X\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<figure id=\"attachment_689\" class=\"wp-caption alignnone\" aria-describedby=\"caption-attachment-689\"><a href=\"http:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-689 tie-appear lazyloaded\" src=\"http:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani.jpg\" sizes=\"auto, (max-width: 600px) 100vw, 600px\" srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani.jpg 600w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani-300x127.jpg 300w\" alt=\"\u00f6rnek veritaban\u0131 tablosu\" width=\"600\" height=\"253\" data-srcset=\"https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani.jpg 600w, https:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani-300x127.jpg 300w\" data-src=\"http:\/\/www.kodlamamerkezi.com\/wp-content\/uploads\/2014\/10\/ornek-veritabani.jpg\" \/><\/a><figcaption id=\"caption-attachment-689\" class=\"wp-caption-text\">Sorgular\u0131n \u00c7al\u0131\u015ft\u0131r\u0131laca\u011f\u0131 \u00d6rnek Veritaban\u0131<\/figcaption><\/figure>\n<h2>Basit Select \u0130fadeleri \u0130le Sorgulama<\/h2>\n<p><strong>En basit olarak tablodaki t\u00fcm kay\u0131tlar\u0131 se\u00e7mek i\u00e7in;<\/strong><\/p>\n<div id=\"crayon-5e419c51a946b825886268\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a946b825886268-1\">1<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a946b825886268-2\">2<\/div>\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a946b825886268-3\">3<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a946b825886268-1\" class=\"crayon-line\"><span class=\"crayon-e \">Select *<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler<\/span><\/div>\n<div id=\"crayon-5e419c51a946b825886268-2\" class=\"crayon-line\"><\/div>\n<div id=\"crayon-5e419c51a946b825886268-3\" class=\"crayon-line\"><span class=\"crayon-e\">Select <\/span><span class=\"crayon-v\">musteriID<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">isim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">soyisim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">dogumtarihi<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">il<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">ilce <\/span><span class=\"crayon-e\">from <\/span><span class=\"crayon-v\">musteriler<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Yukar\u0131daki sorgular \u00e7al\u0131\u015ft\u0131r\u0131ld\u0131\u011f\u0131nda iki sorgu sonucunda da musteriler tablosundaki t\u00fcm kay\u0131tlar listelenecektir. Birinci ifadede t\u00fcm kolon isimlerini teker teker belirtmek yerine * karakteri ile t\u00fcm kolonlar\u0131n se\u00e7ilece\u011fi bildirilmi\u015ftir.<\/p>\n<p><em>Not:<\/em>\u00a0(*) karakteri kolay bir kullan\u0131m sunmas\u0131na ra\u011fmen, t\u00fcm kolon isimlerini teker teker yazman\u0131z\u0131 \u00f6neririm.<\/p>\n<div class=\"google-auto-placed ap_container\"><\/div>\n<p><strong>M\u00fc\u015fterilerin sadece musteriID, isim, soyisim ve il bilgilerine ula\u015fmak istersek;<\/strong><\/p>\n<div id=\"crayon-5e419c51a947a998441159\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a947a998441159-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a947a998441159-1\" class=\"crayon-line\"><span class=\"crayon-e\">Select <\/span><span class=\"crayon-v\">musteriID<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">isim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">soyisim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">il <\/span><span class=\"crayon-e\">from <\/span><span class=\"crayon-v\">musteriler<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Sorgu sonu\u00e7lar\u0131n\u0131 inceledi\u011finizde veri kayna\u011f\u0131ndaki tablolar ile sorgulama sonucu listelenen verilerin kolon isimlerinin ayn\u0131 oldu\u011funu g\u00f6r\u00fcrs\u00fcn\u00fcz. E\u011fer listedeki kolon isimlerini de\u011fi\u015ftirmek isterseniz,\u00a0<em>Alias<\/em>\u00a0kullanmak zorundas\u0131n\u0131z. Yukar\u0131daki sorguyu a\u015fa\u011f\u0131daki gibi de\u011fi\u015ftirelim.<\/p>\n<div id=\"crayon-5e419c51a947f593223576\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a947f593223576-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a947f593223576-1\" class=\"crayon-line\"><span class=\"crayon-e\">Select <\/span><span class=\"crayon-e\">musteriID <\/span><span class=\"crayon-st\">as<\/span> <span class=\"crayon-i\">M<\/span>\u00fc\u015f<span class=\"crayon-v\">teriID<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">isim <\/span><span class=\"crayon-st\">as<\/span> \u0130<span class=\"crayon-v\">sim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">soyisim <\/span><span class=\"crayon-st\">as<\/span> <span class=\"crayon-v\">Soyad<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">il <\/span><span class=\"crayon-st\">as<\/span> <span class=\"crayon-sy\">[<\/span><span class=\"crayon-i\">Bulundu<\/span>\u011f<span class=\"crayon-i\">u<\/span> \u0130<span class=\"crayon-v\">l<\/span><span class=\"crayon-sy\">]<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-v\">musteriler<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><em>Not:<\/em>\u00a0Alias isimleri belirlenirken T\u00fcrk\u00e7e karakter kullan\u0131labilir fakat kelimeler aras\u0131nda bo\u015fluk b\u0131rak\u0131lmaz. \u0130lla ki b\u0131rakacam derseniz aralar\u0131nda bo\u015fluk bulunan kelimeleri [] aras\u0131na alabilirsiniz.<\/p>\n<h2>Sorgu Sonu\u00e7lar\u0131n\u0131n Where Ko\u015fulu \u0130le S\u0131n\u0131rland\u0131r\u0131lmas\u0131<\/h2>\n<p>Yukar\u0131daki sorgulama ile tablodaki t\u00fcm kay\u0131tlara veya istedi\u011fimiz kolonlardaki kay\u0131tlara eri\u015febiliyoruz. Peki t\u00fcm kay\u0131tlara de\u011fil de sadece istedi\u011fimiz, bizim belirledi\u011fimiz ko\u015fula uyan kay\u0131tlar\u0131n listelenmesini istersek? B\u00f6yle bir durumda\u00a0<em>where<\/em>\u00a0operat\u00f6r\u00fcn\u00fc kullanmak zorunday\u0131z.<\/p>\n<div id=\"quads-ad2\" class=\"quads-location quads-ad2\"><ins class=\"adsbygoogle\" data-ad-client=\"ca-pub-5287131492316638\" data-ad-slot=\"7424864537\" data-adsbygoogle-status=\"done\"><ins id=\"aswift_2_expand\"><ins id=\"aswift_2_anchor\"><iframe width=\"0\" height=\"0\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" allowtransparency=\"true\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\" onload=\"var i=this.id,s=window.google_iframe_oncopy,H=s&amp;&amp;s.handlers,h=H&amp;&amp;H[i],w=this.contentWindow,d;try{d=w.document}catch(e){}if(h&amp;&amp;d&amp;&amp;(!d.body||!d.body.firstChild)){if(h.call){setTimeout(h,0)}else if(h.match){try{h=s.upd(h,i)}catch(e){}w.location.replace(h)}}\" id=\"aswift_2\" name=\"aswift_2\" data-mce-fragment=\"1\"><\/iframe><\/ins><\/ins><\/ins><\/div>\n<p><strong>Sadece Antalya\u2019da ya\u015fayan m\u00fc\u015fterilerin t\u00fcm bilgilerini listeleyelim;<\/strong><\/p>\n<div id=\"crayon-5e419c51a9483938350310\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a9483938350310-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a9483938350310-1\" class=\"crayon-line\"><span class=\"crayon-e\">Select <\/span><span class=\"crayon-v\">musteriID<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">isim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">soyisim<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">dogumtarihi<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-v\">il<\/span><span class=\"crayon-sy\">,<\/span> <span class=\"crayon-e\">ilce <\/span><span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler <\/span><span class=\"crayon-e\">where <\/span><span class=\"crayon-v\">il<\/span><span class=\"crayon-o\">=<\/span>\u2019<span class=\"crayon-i\">Antalya<\/span>\u2019<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>Bunun d\u0131\u015f\u0131nda birden fazla ko\u015ful ifadesini birliktede kullanabiliriz. Ko\u015ful ifadeleri mutlaka\u00a0<strong>and<\/strong>\u00a0(ve),\u00a0<strong>or<\/strong>\u00a0(veya),\u00a0<strong>not<\/strong>\u00a0(de\u011fil) operat\u00f6rleri ile birbirinden ayr\u0131lmal\u0131d\u0131r.<\/p>\n<p><strong>Soyismi Demir olan ve Antalya\u2019da ya\u015fayan ki\u015fileri se\u00e7mek istersek;<\/strong><\/p>\n<div id=\"crayon-5e419c51a9487716633989\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a9487716633989-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a9487716633989-1\" class=\"crayon-line\"><span class=\"crayon-e \">Select *<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler <\/span><span class=\"crayon-e\">where <\/span><span class=\"crayon-v\">soyisim<\/span><span class=\"crayon-o\">=<\/span>\u2019<span class=\"crayon-i\">Demir<\/span>\u2019 <span class=\"crayon-st\">and<\/span> <span class=\"crayon-v\">il<\/span><span class=\"crayon-o\">=<\/span>\u2019<span class=\"crayon-i\">Antalya<\/span>\u2019<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><em>Not:<\/em>\u00a0Where ifadesinde kullan\u0131lan and, or ve not operat\u00f6rleri aras\u0131ndaki \u00f6ncelik i\u015flemi \u015fu \u015fekildedir. \u00d6ncelikle parantez i\u00e7erisindeki ifade, sonra s\u0131ras\u0131yla not, and ve or operat\u00f6rleri i\u015flem g\u00f6r\u00fcr.<\/p>\n<p>Ayr\u0131ca sorgulama i\u015flemlerinde kar\u015f\u0131la\u015ft\u0131rma ifadeleri kullan\u0131labilir. \u00d6rne\u011fin b\u00fcy\u00fckt\u00fcr(&gt;), k\u00fc\u00e7\u00fckt\u00fcr(&lt;), e\u015fittir(=), e\u015fitde\u011fildir(!=) gibi programlama dillerinde kullan\u0131lan kar\u015f\u0131la\u015ft\u0131rma ifadeleri sorgularda kullan\u0131labilir.<\/p>\n<div class=\"google-auto-placed ap_container\"><ins class=\"adsbygoogle adsbygoogle-noablate\" data-ad-format=\"auto\" data-ad-client=\"ca-pub-5287131492316638\" data-adsbygoogle-status=\"done\"><ins id=\"aswift_6_expand\"><ins id=\"aswift_6_anchor\"><iframe width=\"620\" height=\"155\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" vspace=\"0\" hspace=\"0\" allowtransparency=\"true\" scrolling=\"no\" allowfullscreen=\"allowfullscreen\" onload=\"var i=this.id,s=window.google_iframe_oncopy,H=s&amp;&amp;s.handlers,h=H&amp;&amp;H[i],w=this.contentWindow,d;try{d=w.document}catch(e){}if(h&amp;&amp;d&amp;&amp;(!d.body||!d.body.firstChild)){if(h.call){setTimeout(h,0)}else if(h.match){try{h=s.upd(h,i)}catch(e){}w.location.replace(h)}}\" id=\"aswift_6\" name=\"aswift_6\" data-mce-fragment=\"1\"><\/iframe><\/ins><\/ins><\/ins><\/div>\n<p><strong>Do\u011fum tarihi 01-01-1985 tarihinden b\u00fcy\u00fck olan m\u00fc\u015fterileri listeleyelim;<\/strong><\/p>\n<div id=\"crayon-5e419c51a948a357820779\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a948a357820779-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a948a357820779-1\" class=\"crayon-line\"><span class=\"crayon-e \">Select *<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler <\/span><span class=\"crayon-e\">where <\/span><span class=\"crayon-v\">dogumtarihi<\/span><span class=\"crayon-o\">&gt;=<\/span>\u2019<span class=\"crayon-cn\">1985<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-cn\">01<\/span><span class=\"crayon-o\">&#8211;<\/span><span class=\"crayon-cn\">01<\/span>\u2019<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h2>Karakter Katarlar\u0131n\u0131 Like Operat\u00f6r\u00fc ile S\u0131n\u0131rlamak<\/h2>\n<p>Yukar\u0131daki \u00f6rneklerde = operat\u00f6r\u00fcn\u00fcn karakter katarlar\u0131n\u0131 da kar\u015f\u0131la\u015ft\u0131rd\u0131\u011f\u0131n\u0131 g\u00f6rd\u00fck. Fakat sql i\u00e7erisinde sadece karakter katarlar\u0131n\u0131 kar\u015f\u0131la\u015ft\u0131rmak i\u00e7in \u00f6zelle\u015ftirilmi\u015f Like operat\u00f6r\u00fc bulunmaktad\u0131r. Ayr\u0131ca Like operat\u00f6r\u00fc baz\u0131 \u00f6zel parametrelerle \u00e7ok i\u015flevsel sorgulamalar yapmaya olanak verir.<\/p>\n<p><strong>Soyad\u0131 D harfi ile ba\u015flayan m\u00fc\u015fterileri listeleyelim;<\/strong><\/p>\n<div id=\"crayon-5e419c51a9494224126016\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a9494224126016-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a9494224126016-1\" class=\"crayon-line\"><span class=\"crayon-e \">Select *<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler <\/span><span class=\"crayon-e\">where <\/span><span class=\"crayon-e\">soyisim <\/span><span class=\"crayon-i\">like<\/span> \u2018<span class=\"crayon-v\">D<\/span><span class=\"crayon-o\">%<\/span>\u2019<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p><em>Not:<\/em>\u00a0% i\u015fareti bir veya daha fazla karakteri temsil etmek i\u00e7in kullan\u0131lm\u0131\u015ft\u0131r. Buna benzer olarak _ i\u015fareti sadece tek bir karakteri temsil eder.<\/p>\n<p><strong>Sonu en ile biten ve ad\u0131 3 harften olu\u015fan m\u00fc\u015fterileri listeleyelim;<\/strong><\/p>\n<div id=\"crayon-5e419c51a9499835594676\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a9499835594676-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a9499835594676-1\" class=\"crayon-line\"><span class=\"crayon-e \">Select *<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler <\/span><span class=\"crayon-e\">where <\/span><span class=\"crayon-e\">isim <\/span><span class=\"crayon-i\">like<\/span> \u2018<span class=\"crayon-i\">_en<\/span>\u2019<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<h2>Sorgu Sonu\u00e7lar\u0131n\u0131n Order By ile S\u0131ralanmas\u0131<\/h2>\n<p>Select ifadeleriyle birlikte en fazla kullan\u0131lan ifadelerden biride Order By s\u0131ralama operat\u00f6r\u00fcd\u00fcr.\u00a0 Sorgu sonu\u00e7lar\u0131 belirlenen kolon isimlerine g\u00f6re b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe yada k\u00fc\u00e7\u00fckten b\u00fcy\u00fc\u011fe do\u011fru s\u0131ralanabilmektedir.<\/p>\n<p><strong>M\u00fc\u015fterilerimizi do\u011fum tarihlerine g\u00f6re s\u0131ralayal\u0131m;<\/strong><\/p>\n<div id=\"crayon-5e419c51a949c583488525\" class=\"crayon-syntax crayon-theme-cg-cookie crayon-font-monaco crayon-os-pc print-yes notranslate\" data-settings=\" minimize scroll-always\">\n<div class=\"crayon-plain-wrap\"><\/div>\n<div class=\"crayon-main\">\n<table class=\"crayon-table\">\n<tbody>\n<tr class=\"crayon-row\">\n<td class=\"crayon-nums \" data-settings=\"hide\">\n<div class=\"crayon-nums-content\">\n<div class=\"crayon-num\" data-line=\"crayon-5e419c51a949c583488525-1\">1<\/div>\n<\/div>\n<\/td>\n<td class=\"crayon-code\">\n<div class=\"crayon-pre\">\n<div id=\"crayon-5e419c51a949c583488525-1\" class=\"crayon-line\"><span class=\"crayon-e \">Select *<\/span> <span class=\"crayon-e\">from <\/span><span class=\"crayon-e\">musteriler <\/span><span class=\"crayon-e\">order <\/span><span class=\"crayon-e\">by <\/span><span class=\"crayon-e\">dogumtarihi <\/span><span class=\"crayon-v\">asc<\/span><\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<p>\u00d6rne\u011fimizde m\u00fc\u015fteriler do\u011fum tarihlerine g\u00f6re k\u00fc\u00e7\u00fckten b\u00fcy\u00fc\u011fe do\u011fru s\u0131raland\u0131. Tam tersi olarak b\u00fcy\u00fckten k\u00fc\u00e7\u00fc\u011fe s\u0131ralama yapmak istersek\u00a0<strong>asc<\/strong>\u00a0yerine\u00a0<strong>desc<\/strong>\u00a0operat\u00f6r\u00fcn\u00fc kullanmam\u0131z gerekir.<\/p>\n<p><em>Not:<\/em>\u00a0Order By operat\u00f6r\u00fc Select ifadesinde her zaman en son olarak yaz\u0131l\u0131r.<\/p>\n<p>Sql Select sorgusunu en \u00e7ok kullan\u0131lan ifadelerle birlikte anlatmaya \u00e7al\u0131\u015ft\u0131m. Yukar\u0131da a\u00e7\u0131klananlardan farkl\u0131 olarak select deyimi i\u00e7erisinde onlarca farkl\u0131 operat\u00f6r yer almaktad\u0131r. Baz\u0131lar\u0131 tekil tablolarla kullan\u0131l\u0131rken, baz\u0131lar\u0131 da sadece ili\u015fkili tablolar \u00fczerinde sorgulama yapmada kullan\u0131l\u0131rlar. Hepsini ayr\u0131 ayr\u0131 detaylar\u0131yla a\u00e7\u0131klamak konunun \u00e7ok fazla uzamas\u0131na neden olaca\u011f\u0131 i\u00e7in de\u011finilmemi\u015ftir.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Select ifadesi, herhangi bir veritaban\u0131 i\u00e7erisinde ki verileri sorgulamak i\u00e7in kullan\u0131lan en basit ayn\u0131 zamanda en kapsaml\u0131 komuttur. Bu yaz\u0131mda [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[180],"tags":[110],"class_list":["post-919","post","type-post","status-publish","format-standard","hentry","category-sql","tag-sql-sql-ornek"],"_links":{"self":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/919","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/comments?post=919"}],"version-history":[{"count":1,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/919\/revisions"}],"predecessor-version":[{"id":2140,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/posts\/919\/revisions\/2140"}],"wp:attachment":[{"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/media?parent=919"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/categories?post=919"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.aydiner.gen.tr\/index.php\/wp-json\/wp\/v2\/tags?post=919"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}