{"id":10101,"date":"2024-04-06T16:14:09","date_gmt":"2024-04-06T13:14:09","guid":{"rendered":"https:\/\/sunucun.com.tr\/bilgi\/?post_type=dt_articles&#038;p=10101"},"modified":"2026-02-06T20:41:18","modified_gmt":"2026-02-06T17:41:18","slug":"mysql-select-sorgusu","status":"publish","type":"post","link":"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/","title":{"rendered":"MySQL SELECT Sorgusu: Veritaban\u0131ndan Veri Se\u00e7me"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_84 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-2\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-3\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-4\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-5\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-2\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-6\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-7\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-3\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-8\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-9\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-4\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-10\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-11\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-5\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-12\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-13\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-14\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-6\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-15\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-16\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-17\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-7\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-18\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-19\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-20\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-8\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-21\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-22\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-23\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-24\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-9\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-25\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-26\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-27\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-28\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-10\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-29\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#SELECT_Sorgusunun_MySQLde_Kullanimi\" >SELECT Sorgusunun MySQL&#8217;de Kullan\u0131m\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-30\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-31\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-32\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-33\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-34\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-11\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-35\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#SELECT_Sorgusunun_MySQLde_Kullanimi-2\" >SELECT Sorgusunun MySQL&#8217;de Kullan\u0131m\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-36\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-37\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-38\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-39\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-40\" >Sonu\u00e7:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Ornek_SELECT_Sorgulari_ve_Uygulamalari-12\" >\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\/#Sonuc-41\" >Sonu\u00e7:<\/a><\/li><\/ul><\/nav><\/div>\n\r\n<ul>\r\n<li><strong>S\u0131ral\u0131 veri se\u00e7me (ORDER BY):<\/strong><\/li>\r\n<\/ul>\r\n\r\n<p class=\"wp-block-paragraph\">Verilerinizi belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in ORDER BY ifadesini kullanabilirsiniz:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorgu, verilerinizi belirtilen s\u00fctuna g\u00f6re artan (ASC) veya azalan (DESC) s\u0131rayla s\u0131ralar. \u00d6rne\u011fin, m\u00fc\u015fterilerinizi isimlerine g\u00f6re alfabetik olarak s\u0131ralayabilirsiniz.<\/p>\r\n\r\n\r\n\r\n<ul class=\"wp-block-list\">\r\n<li><strong>Gruplama ve \u00f6zetleme (GROUP BY):<\/strong><\/li>\r\n<\/ul>\r\n\r\n<p class=\"wp-block-paragraph\">GROUP BY ifadesi, verileri belirli bir s\u00fctuna g\u00f6re gruplamak ve bu gruplar \u00fczerinde \u00f6zetleme i\u015flemleri yapmak i\u00e7in kullan\u0131l\u0131r:<\/p>\r\n\r\n\r\n\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun, COUNT(*) \r\nFROM tablo_ad\u0131 \r\nGROUP BY s\u00fctun;\r\n<\/code><\/pre>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Bu sorgu, belirli bir s\u00fctuna g\u00f6re verileri gruplar ve her grubun ka\u00e7 kay\u0131t i\u00e7erdi\u011fini d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, \u015fehirlerine g\u00f6re m\u00fc\u015fteri say\u0131s\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\r\n\r\n\r\n\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc\"><\/span>Sonu\u00e7:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan veri \u00e7ekmek i\u00e7in temel ve son derece g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, SELECT sorgusunun farkl\u0131 kullan\u0131m yollar\u0131n\u0131 ve \u00f6rneklerini ele ald\u0131k. \u0130htiya\u00e7lar\u0131n\u0131za uygun SELECT sorgular\u0131 yazarak, veritaban\u0131n\u0131zdaki verileri kolayca ve etkili bir \u015fekilde y\u00f6netebilirsiniz. Daha ileri d\u00fczeyde veri i\u015flemleri i\u00e7in WHERE, ORDER BY ve GROUP BY gibi ek \u00f6zellikleri de kullanarak verilerinizi daha hassas ve \u00f6zel \u015fekilde filtreleyebilirsiniz.<\/p>\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\">Veri sorgulama ile ilgili daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\">MySQL&#8217;de ORDER BY ile Veri S\u0131ralama<\/a> makalesine g\u00f6z atabilirsiniz.<\/p>\r\n\r\n<p>&nbsp;<\/p><!-- \/wp:list -->\r\n\r\n<!-- wp:list {\"start\":3} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Ko\u015fullu veri se\u00e7me (WHERE):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir ko\u015fula g\u00f6re filtrelemek i\u00e7in WHERE ko\u015fulunu kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nWHERE ko\u015ful;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, yaln\u0131zca belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan verileri d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, belirli bir \u015fehirde ya\u015fayan m\u00fc\u015fterileri listelemek istedi\u011finizde bu t\u00fcr bir sorgu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>S\u0131ral\u0131 veri se\u00e7me (ORDER BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in ORDER BY ifadesini kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, verilerinizi belirtilen s\u00fctuna g\u00f6re artan (ASC) veya azalan (DESC) s\u0131rayla s\u0131ralar. \u00d6rne\u011fin, m\u00fc\u015fterilerinizi isimlerine g\u00f6re alfabetik olarak s\u0131ralayabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":5} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Gruplama ve \u00f6zetleme (GROUP BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>GROUP BY ifadesi, verileri belirli bir s\u00fctuna g\u00f6re gruplamak ve bu gruplar \u00fczerinde \u00f6zetleme i\u015flemleri yapmak i\u00e7in kullan\u0131l\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun, COUNT(*) \r\nFROM tablo_ad\u0131 \r\nGROUP BY s\u00fctun;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirli bir s\u00fctuna g\u00f6re verileri gruplar ve her grubun ka\u00e7 kay\u0131t i\u00e7erdi\u011fini d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, \u015fehirlerine g\u00f6re m\u00fc\u015fteri say\u0131s\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc-2\"><\/span>Sonu\u00e7:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan veri \u00e7ekmek i\u00e7in temel ve son derece g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, SELECT sorgusunun farkl\u0131 kullan\u0131m yollar\u0131n\u0131 ve \u00f6rneklerini ele ald\u0131k. \u0130htiya\u00e7lar\u0131n\u0131za uygun SELECT sorgular\u0131 yazarak, veritaban\u0131n\u0131zdaki verileri kolayca ve etkili bir \u015fekilde y\u00f6netebilirsiniz. Daha ileri d\u00fczeyde veri i\u015flemleri i\u00e7in WHERE, ORDER BY ve GROUP BY gibi ek \u00f6zellikleri de kullanarak verilerinizi daha hassas ve \u00f6zel \u015fekilde filtreleyebilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Veri sorgulama ile ilgili daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\">MySQL&#8217;de ORDER BY ile Veri S\u0131ralama<\/a> makalesine g\u00f6z atabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n<p>&nbsp;<\/p><!-- \/wp:post-content --><!-- \/wp:list -->\r\n\r\n<!-- wp:list {\"start\":2} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Belirli s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>E\u011fer yaln\u0131zca belirli s\u00fctunlara ait verileri se\u00e7mek istiyorsan\u0131z, s\u00fctun isimlerini belirtebilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun1, s\u00fctun2 \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodan sadece &#8220;s\u00fctun1&#8221; ve &#8220;s\u00fctun2&#8221; s\u00fctunlar\u0131n\u0131 se\u00e7er. Bu sayede, gereksiz verilerle u\u011fra\u015fmak zorunda kalmazs\u0131n\u0131z ve veri i\u015flemleriniz daha h\u0131zl\u0131 ger\u00e7ekle\u015fir.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":3} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Ko\u015fullu veri se\u00e7me (WHERE):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir ko\u015fula g\u00f6re filtrelemek i\u00e7in WHERE ko\u015fulunu kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nWHERE ko\u015ful;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, yaln\u0131zca belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan verileri d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, belirli bir \u015fehirde ya\u015fayan m\u00fc\u015fterileri listelemek istedi\u011finizde bu t\u00fcr bir sorgu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>S\u0131ral\u0131 veri se\u00e7me (ORDER BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in ORDER BY ifadesini kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, verilerinizi belirtilen s\u00fctuna g\u00f6re artan (ASC) veya azalan (DESC) s\u0131rayla s\u0131ralar. \u00d6rne\u011fin, m\u00fc\u015fterilerinizi isimlerine g\u00f6re alfabetik olarak s\u0131ralayabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":5} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Gruplama ve \u00f6zetleme (GROUP BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>GROUP BY ifadesi, verileri belirli bir s\u00fctuna g\u00f6re gruplamak ve bu gruplar \u00fczerinde \u00f6zetleme i\u015flemleri yapmak i\u00e7in kullan\u0131l\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun, COUNT(*) \r\nFROM tablo_ad\u0131 \r\nGROUP BY s\u00fctun;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirli bir s\u00fctuna g\u00f6re verileri gruplar ve her grubun ka\u00e7 kay\u0131t i\u00e7erdi\u011fini d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, \u015fehirlerine g\u00f6re m\u00fc\u015fteri say\u0131s\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc-3\"><\/span>Sonu\u00e7:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan veri \u00e7ekmek i\u00e7in temel ve son derece g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, SELECT sorgusunun farkl\u0131 kullan\u0131m yollar\u0131n\u0131 ve \u00f6rneklerini ele ald\u0131k. \u0130htiya\u00e7lar\u0131n\u0131za uygun SELECT sorgular\u0131 yazarak, veritaban\u0131n\u0131zdaki verileri kolayca ve etkili bir \u015fekilde y\u00f6netebilirsiniz. Daha ileri d\u00fczeyde veri i\u015flemleri i\u00e7in WHERE, ORDER BY ve GROUP BY gibi ek \u00f6zellikleri de kullanarak verilerinizi daha hassas ve \u00f6zel \u015fekilde filtreleyebilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Veri sorgulama ile ilgili daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\">MySQL&#8217;de ORDER BY ile Veri S\u0131ralama<\/a> makalesine g\u00f6z atabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n<p>&nbsp;<\/p><!-- \/wp:post-content --><!-- \/wp:list -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>T\u00fcm s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodaki t\u00fcm s\u00fctunlar\u0131 se\u00e7er. T\u00fcm verileri g\u00f6rmek istedi\u011finizde bu sorgu kullan\u0131\u015fl\u0131d\u0131r.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":2} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Belirli s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>E\u011fer yaln\u0131zca belirli s\u00fctunlara ait verileri se\u00e7mek istiyorsan\u0131z, s\u00fctun isimlerini belirtebilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun1, s\u00fctun2 \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodan sadece &#8220;s\u00fctun1&#8221; ve &#8220;s\u00fctun2&#8221; s\u00fctunlar\u0131n\u0131 se\u00e7er. Bu sayede, gereksiz verilerle u\u011fra\u015fmak zorunda kalmazs\u0131n\u0131z ve veri i\u015flemleriniz daha h\u0131zl\u0131 ger\u00e7ekle\u015fir.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":3} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Ko\u015fullu veri se\u00e7me (WHERE):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir ko\u015fula g\u00f6re filtrelemek i\u00e7in WHERE ko\u015fulunu kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nWHERE ko\u015ful;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, yaln\u0131zca belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan verileri d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, belirli bir \u015fehirde ya\u015fayan m\u00fc\u015fterileri listelemek istedi\u011finizde bu t\u00fcr bir sorgu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>S\u0131ral\u0131 veri se\u00e7me (ORDER BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in ORDER BY ifadesini kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, verilerinizi belirtilen s\u00fctuna g\u00f6re artan (ASC) veya azalan (DESC) s\u0131rayla s\u0131ralar. \u00d6rne\u011fin, m\u00fc\u015fterilerinizi isimlerine g\u00f6re alfabetik olarak s\u0131ralayabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":5} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Gruplama ve \u00f6zetleme (GROUP BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>GROUP BY ifadesi, verileri belirli bir s\u00fctuna g\u00f6re gruplamak ve bu gruplar \u00fczerinde \u00f6zetleme i\u015flemleri yapmak i\u00e7in kullan\u0131l\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun, COUNT(*) \r\nFROM tablo_ad\u0131 \r\nGROUP BY s\u00fctun;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirli bir s\u00fctuna g\u00f6re verileri gruplar ve her grubun ka\u00e7 kay\u0131t i\u00e7erdi\u011fini d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, \u015fehirlerine g\u00f6re m\u00fc\u015fteri say\u0131s\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc-4\"><\/span>Sonu\u00e7:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan veri \u00e7ekmek i\u00e7in temel ve son derece g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, SELECT sorgusunun farkl\u0131 kullan\u0131m yollar\u0131n\u0131 ve \u00f6rneklerini ele ald\u0131k. \u0130htiya\u00e7lar\u0131n\u0131za uygun SELECT sorgular\u0131 yazarak, veritaban\u0131n\u0131zdaki verileri kolayca ve etkili bir \u015fekilde y\u00f6netebilirsiniz. Daha ileri d\u00fczeyde veri i\u015flemleri i\u00e7in WHERE, ORDER BY ve GROUP BY gibi ek \u00f6zellikleri de kullanarak verilerinizi daha hassas ve \u00f6zel \u015fekilde filtreleyebilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Veri sorgulama ile ilgili daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\">MySQL&#8217;de ORDER BY ile Veri S\u0131ralama<\/a> makalesine g\u00f6z atabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n<p>&nbsp;<\/p><!-- \/wp:post-content --><!-- \/wp:list -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>SELECT:<\/strong> Belirli s\u00fctunlar\u0131n se\u00e7ilmesini sa\u011flar.<\/li>\r\n<!-- \/wp:list-item -->\r\n\r\n<!-- wp:list-item -->\r\n<li><strong>s\u00fctun1, s\u00fctun2, &#8230;:<\/strong> Se\u00e7mek istedi\u011finiz s\u00fctunlar\u0131 belirtir. E\u011fer t\u00fcm s\u00fctunlar\u0131 se\u00e7mek istiyorsan\u0131z, * (y\u0131ld\u0131z) sembol\u00fcn\u00fc kullanabilirsiniz.<\/li>\r\n<!-- \/wp:list-item -->\r\n\r\n<!-- wp:list-item -->\r\n<li><strong>FROM:<\/strong> Verinin hangi tablodan al\u0131naca\u011f\u0131n\u0131 belirtir.<\/li>\r\n<!-- wp:list-item -->\r\n<li><strong>tablo_ad\u0131:<\/strong> Verilerin \u00e7ekilece\u011fi tabloyu belirtir.<\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- \/wp:list-item -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>SELECT sorgusu, \u00e7e\u015fitli ek \u00f6zelliklerle birle\u015ftirildi\u011finde \u00e7ok daha g\u00fc\u00e7l\u00fc hale gelir. Bu ek \u00f6zellikler, verilerin filtrelenmesi, s\u0131ralanmas\u0131 ve belirli kriterlere g\u00f6re gruplanmas\u0131 gibi i\u015flemleri i\u00e7erir.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:image {\"id\":10102,\"width\":\"485px\",\"height\":\"auto\",\"sizeSlug\":\"full\",\"linkDestination\":\"none\"} -->\r\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"998\" height=\"692\" class=\"wp-image-10102\" style=\"width: 485px; height: auto;\" src=\"https:\/\/www.sunucun.com.tr\/blog\/\/wp-content\/uploads\/2024\/04\/logo-mysql.png\" alt=\"MySQL Logo\" srcset=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/logo-mysql.png 998w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/logo-mysql-300x208.png 300w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/logo-mysql-768x533.png 768w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ornek_SELECT_Sorgulari_ve_Uygulamalari\"><\/span>\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusunu kullanarak \u00e7e\u015fitli veri se\u00e7me i\u015flemleri ger\u00e7ekle\u015ftirebilirsiniz. A\u015fa\u011f\u0131da farkl\u0131 durumlar i\u00e7in kullan\u0131labilecek SELECT sorgular\u0131 \u00f6rnekleri yer almaktad\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>T\u00fcm s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodaki t\u00fcm s\u00fctunlar\u0131 se\u00e7er. T\u00fcm verileri g\u00f6rmek istedi\u011finizde bu sorgu kullan\u0131\u015fl\u0131d\u0131r.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":2} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Belirli s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>E\u011fer yaln\u0131zca belirli s\u00fctunlara ait verileri se\u00e7mek istiyorsan\u0131z, s\u00fctun isimlerini belirtebilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun1, s\u00fctun2 \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodan sadece &#8220;s\u00fctun1&#8221; ve &#8220;s\u00fctun2&#8221; s\u00fctunlar\u0131n\u0131 se\u00e7er. Bu sayede, gereksiz verilerle u\u011fra\u015fmak zorunda kalmazs\u0131n\u0131z ve veri i\u015flemleriniz daha h\u0131zl\u0131 ger\u00e7ekle\u015fir.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":3} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Ko\u015fullu veri se\u00e7me (WHERE):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir ko\u015fula g\u00f6re filtrelemek i\u00e7in WHERE ko\u015fulunu kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nWHERE ko\u015ful;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, yaln\u0131zca belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan verileri d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, belirli bir \u015fehirde ya\u015fayan m\u00fc\u015fterileri listelemek istedi\u011finizde bu t\u00fcr bir sorgu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>S\u0131ral\u0131 veri se\u00e7me (ORDER BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in ORDER BY ifadesini kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, verilerinizi belirtilen s\u00fctuna g\u00f6re artan (ASC) veya azalan (DESC) s\u0131rayla s\u0131ralar. \u00d6rne\u011fin, m\u00fc\u015fterilerinizi isimlerine g\u00f6re alfabetik olarak s\u0131ralayabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":5} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Gruplama ve \u00f6zetleme (GROUP BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>GROUP BY ifadesi, verileri belirli bir s\u00fctuna g\u00f6re gruplamak ve bu gruplar \u00fczerinde \u00f6zetleme i\u015flemleri yapmak i\u00e7in kullan\u0131l\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun, COUNT(*) \r\nFROM tablo_ad\u0131 \r\nGROUP BY s\u00fctun;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirli bir s\u00fctuna g\u00f6re verileri gruplar ve her grubun ka\u00e7 kay\u0131t i\u00e7erdi\u011fini d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, \u015fehirlerine g\u00f6re m\u00fc\u015fteri say\u0131s\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc-5\"><\/span>Sonu\u00e7:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan veri \u00e7ekmek i\u00e7in temel ve son derece g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, SELECT sorgusunun farkl\u0131 kullan\u0131m yollar\u0131n\u0131 ve \u00f6rneklerini ele ald\u0131k. \u0130htiya\u00e7lar\u0131n\u0131za uygun SELECT sorgular\u0131 yazarak, veritaban\u0131n\u0131zdaki verileri kolayca ve etkili bir \u015fekilde y\u00f6netebilirsiniz. Daha ileri d\u00fczeyde veri i\u015flemleri i\u00e7in WHERE, ORDER BY ve GROUP BY gibi ek \u00f6zellikleri de kullanarak verilerinizi daha hassas ve \u00f6zel \u015fekilde filtreleyebilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Veri sorgulama ile ilgili daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\">MySQL&#8217;de ORDER BY ile Veri S\u0131ralama<\/a> makalesine g\u00f6z atabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n<p>&nbsp;<\/p><!-- \/wp:post-content --><!-- \/wp:list --><!-- wp:post-content --><!-- wp:paragraph -->\r\n<p>MySQL, d\u00fcnya genelinde bir\u00e7ok uygulamada kullan\u0131lan pop\u00fcler bir a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir (RDBMS). Veritaban\u0131 i\u00e7erisindeki verilerin etkili bir \u015fekilde y\u00f6netilmesi ve istenilen bilgilere ula\u015f\u0131lmas\u0131 i\u00e7in veri se\u00e7me i\u015flemleri olduk\u00e7a \u00f6nemlidir. MySQL&#8217;de veri se\u00e7me i\u015flemi, temel olarak SELECT sorgusu ile ger\u00e7ekle\u015ftirilir. Bu makalede, SELECT sorgusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, veri se\u00e7me i\u015fleminin farkl\u0131 yollar\u0131n\u0131 ve \u00e7e\u015fitli \u00f6rnekleri detayl\u0131 bir \u015fekilde ele alaca\u011f\u0131z.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"SELECT_Sorgusunun_MySQLde_Kullanimi\"><\/span>SELECT Sorgusunun MySQL&#8217;de Kullan\u0131m\u0131:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan belirli verileri se\u00e7mek i\u00e7in kullan\u0131lan en temel ve yayg\u0131n sorgulardan biridir. SELECT sorgusu ile bir tablodan istenen s\u00fctunlar veya belirli kriterlere g\u00f6re filtrelenmi\u015f veriler se\u00e7ilebilir. \u0130\u015fte SELECT sorgusunun temel kullan\u0131m \u015fekli:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun1, s\u00fctun2, ... \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Yukar\u0131daki sorgu \u015fablonunda:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>SELECT:<\/strong> Belirli s\u00fctunlar\u0131n se\u00e7ilmesini sa\u011flar.<\/li>\r\n<!-- \/wp:list-item -->\r\n\r\n<!-- wp:list-item -->\r\n<li><strong>s\u00fctun1, s\u00fctun2, &#8230;:<\/strong> Se\u00e7mek istedi\u011finiz s\u00fctunlar\u0131 belirtir. E\u011fer t\u00fcm s\u00fctunlar\u0131 se\u00e7mek istiyorsan\u0131z, * (y\u0131ld\u0131z) sembol\u00fcn\u00fc kullanabilirsiniz.<\/li>\r\n<!-- \/wp:list-item -->\r\n\r\n<!-- wp:list-item -->\r\n<li><strong>FROM:<\/strong> Verinin hangi tablodan al\u0131naca\u011f\u0131n\u0131 belirtir.<\/li>\r\n<!-- wp:list-item -->\r\n<li><strong>tablo_ad\u0131:<\/strong> Verilerin \u00e7ekilece\u011fi tabloyu belirtir.<\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- \/wp:list -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>SELECT sorgusu, \u00e7e\u015fitli ek \u00f6zelliklerle birle\u015ftirildi\u011finde \u00e7ok daha g\u00fc\u00e7l\u00fc hale gelir. Bu ek \u00f6zellikler, verilerin filtrelenmesi, s\u0131ralanmas\u0131 ve belirli kriterlere g\u00f6re gruplanmas\u0131 gibi i\u015flemleri i\u00e7erir.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:image {\"id\":10102,\"width\":\"485px\",\"height\":\"auto\",\"sizeSlug\":\"full\",\"linkDestination\":\"none\"} -->\r\n<figure class=\"wp-block-image size-full is-resized\"><img fetchpriority=\"high\" decoding=\"async\" width=\"998\" height=\"692\" class=\"wp-image-10102\" style=\"width: 485px; height: auto;\" src=\"https:\/\/www.sunucun.com.tr\/blog\/\/wp-content\/uploads\/2024\/04\/logo-mysql.png\" alt=\"MySQL Logo\" srcset=\"https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/logo-mysql.png 998w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/logo-mysql-300x208.png 300w, https:\/\/sunucun.com.tr\/blog\/wp-content\/uploads\/2024\/04\/logo-mysql-768x533.png 768w\" sizes=\"(max-width: 998px) 100vw, 998px\" \/><\/figure>\r\n<!-- \/wp:image -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Ornek_SELECT_Sorgulari_ve_Uygulamalari-2\"><\/span>\u00d6rnek SELECT Sorgular\u0131 ve Uygulamalar\u0131:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusunu kullanarak \u00e7e\u015fitli veri se\u00e7me i\u015flemleri ger\u00e7ekle\u015ftirebilirsiniz. A\u015fa\u011f\u0131da farkl\u0131 durumlar i\u00e7in kullan\u0131labilecek SELECT sorgular\u0131 \u00f6rnekleri yer almaktad\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>T\u00fcm s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodaki t\u00fcm s\u00fctunlar\u0131 se\u00e7er. T\u00fcm verileri g\u00f6rmek istedi\u011finizde bu sorgu kullan\u0131\u015fl\u0131d\u0131r.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":2} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Belirli s\u00fctunlar\u0131 se\u00e7mek:<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>E\u011fer yaln\u0131zca belirli s\u00fctunlara ait verileri se\u00e7mek istiyorsan\u0131z, s\u00fctun isimlerini belirtebilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun1, s\u00fctun2 \r\nFROM tablo_ad\u0131;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirtilen tablodan sadece &#8220;s\u00fctun1&#8221; ve &#8220;s\u00fctun2&#8221; s\u00fctunlar\u0131n\u0131 se\u00e7er. Bu sayede, gereksiz verilerle u\u011fra\u015fmak zorunda kalmazs\u0131n\u0131z ve veri i\u015flemleriniz daha h\u0131zl\u0131 ger\u00e7ekle\u015fir.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":3} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Ko\u015fullu veri se\u00e7me (WHERE):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir ko\u015fula g\u00f6re filtrelemek i\u00e7in WHERE ko\u015fulunu kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nWHERE ko\u015ful;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, yaln\u0131zca belirtti\u011finiz ko\u015fulu kar\u015f\u0131layan verileri d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, belirli bir \u015fehirde ya\u015fayan m\u00fc\u015fterileri listelemek istedi\u011finizde bu t\u00fcr bir sorgu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>S\u0131ral\u0131 veri se\u00e7me (ORDER BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>Verilerinizi belirli bir s\u00fctuna g\u00f6re s\u0131ralamak i\u00e7in ORDER BY ifadesini kullanabilirsiniz:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT * \r\nFROM tablo_ad\u0131 \r\nORDER BY s\u00fctun ASC\/DESC;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, verilerinizi belirtilen s\u00fctuna g\u00f6re artan (ASC) veya azalan (DESC) s\u0131rayla s\u0131ralar. \u00d6rne\u011fin, m\u00fc\u015fterilerinizi isimlerine g\u00f6re alfabetik olarak s\u0131ralayabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:list {\"start\":5} -->\r\n<ul><!-- wp:list-item -->\r\n<li><strong>Gruplama ve \u00f6zetleme (GROUP BY):<\/strong><\/li>\r\n<!-- \/wp:list-item --><\/ul>\r\n<!-- wp:paragraph -->\r\n<p>GROUP BY ifadesi, verileri belirli bir s\u00fctuna g\u00f6re gruplamak ve bu gruplar \u00fczerinde \u00f6zetleme i\u015flemleri yapmak i\u00e7in kullan\u0131l\u0131r:<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:code -->\r\n<pre class=\"wp-block-code\"><code>SELECT s\u00fctun, COUNT(*) \r\nFROM tablo_ad\u0131 \r\nGROUP BY s\u00fctun;\r\n<\/code><\/pre>\r\n<!-- \/wp:code -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Bu sorgu, belirli bir s\u00fctuna g\u00f6re verileri gruplar ve her grubun ka\u00e7 kay\u0131t i\u00e7erdi\u011fini d\u00f6nd\u00fcr\u00fcr. \u00d6rne\u011fin, \u015fehirlerine g\u00f6re m\u00fc\u015fteri say\u0131s\u0131n\u0131 \u00f6\u011frenmek i\u00e7in bu sorguyu kullanabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:heading {\"level\":3} -->\r\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"Sonuc-6\"><\/span>Sonu\u00e7:<span class=\"ez-toc-section-end\"><\/span><\/h3>\r\n<!-- \/wp:heading -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>MySQL&#8217;de SELECT sorgusu, veritaban\u0131ndan veri \u00e7ekmek i\u00e7in temel ve son derece g\u00fc\u00e7l\u00fc bir ara\u00e7t\u0131r. Bu makalede, SELECT sorgusunun farkl\u0131 kullan\u0131m yollar\u0131n\u0131 ve \u00f6rneklerini ele ald\u0131k. \u0130htiya\u00e7lar\u0131n\u0131za uygun SELECT sorgular\u0131 yazarak, veritaban\u0131n\u0131zdaki verileri kolayca ve etkili bir \u015fekilde y\u00f6netebilirsiniz. Daha ileri d\u00fczeyde veri i\u015flemleri i\u00e7in WHERE, ORDER BY ve GROUP BY gibi ek \u00f6zellikleri de kullanarak verilerinizi daha hassas ve \u00f6zel \u015fekilde filtreleyebilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n\r\n<!-- wp:paragraph -->\r\n<p>Veri sorgulama ile ilgili daha fazla bilgi edinmek i\u00e7in <a href=\"https:\/\/sunucun.com.tr\/blog\/mysql-select-sorgusu\">MySQL&#8217;de ORDER BY ile Veri S\u0131ralama<\/a> makalesine g\u00f6z atabilirsiniz.<\/p>\r\n<!-- \/wp:paragraph -->\r\n<p>&nbsp;<\/p><!-- \/wp:post-content -->","protected":false},"excerpt":{"rendered":"<p>MySQL, d\u00fcnya genelinde bir\u00e7ok uygulamada kullan\u0131lan pop\u00fcler bir a\u00e7\u0131k kaynakl\u0131 ili\u015fkisel veritaban\u0131 y\u00f6netim sistemidir (RDBMS). Veritaban\u0131 i\u00e7erisindeki verilerin etkili bir \u015fekilde y\u00f6netilmesi ve istenilen bilgilere ula\u015f\u0131lmas\u0131 i\u00e7in veri se\u00e7me i\u015flemleri olduk\u00e7a \u00f6nemlidir. MySQL&#8217;de veri se\u00e7me i\u015flemi, temel olarak SELECT sorgusu ile ger\u00e7ekle\u015ftirilir. Bu makalede, SELECT sorgusunun nas\u0131l kullan\u0131laca\u011f\u0131n\u0131, veri se\u00e7me i\u015fleminin farkl\u0131 yollar\u0131n\u0131 ve \u00e7e\u015fitli&hellip;<\/p>\n","protected":false},"author":1,"featured_media":10103,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[1525,1521],"tags":[],"class_list":["post-10101","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-siber-guvenlik","category-teknoloji"],"_links":{"self":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10101","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/comments?post=10101"}],"version-history":[{"count":3,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10101\/revisions"}],"predecessor-version":[{"id":19913,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/posts\/10101\/revisions\/19913"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media\/10103"}],"wp:attachment":[{"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/media?parent=10101"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/categories?post=10101"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sunucun.com.tr\/blog\/wp-json\/wp\/v2\/tags?post=10101"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}