﻿
{"id":11290,"date":"2019-06-24T20:03:58","date_gmt":"2019-06-24T20:03:58","guid":{"rendered":"https:\/\/www.gencayyildiz.com\/blog\/?p=11290"},"modified":"2019-06-24T20:03:58","modified_gmt":"2019-06-24T20:03:58","slug":"mongodb-karsilastirma-sorgu-operatorleri","status":"publish","type":"post","link":"https:\/\/www.gencayyildiz.com\/blog\/mongodb-karsilastirma-sorgu-operatorleri\/","title":{"rendered":"MongoDB &#8211; Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri"},"content":{"rendered":"<div id=\"fb-root\"><\/div>\n<p>Merhaba,<\/p>\n<p>NoSQL yakla\u015f\u0131m\u0131n\u0131 benimsemi\u015f veritabanlar\u0131ndan biri olan MongoDB&#8217;de sorgu olu\u015ftururken kar\u015f\u0131la\u015ft\u0131rma mant\u0131\u011f\u0131n\u0131 uygulayabilmek i\u00e7in a\u015fa\u011f\u0131daki operat\u00f6rleri kullanabilirsiniz.<\/p>\n<p>\u00d6ncelikle \u00f6rneklendirmede kullanaca\u011f\u0131m\u0131z modeli ve veritaban\u0131 i\u00e7erisindeki documentleri a\u015fa\u011f\u0131da ele alal\u0131m;<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\nconst mongoose = require(&quot;mongoose&quot;);\r\n\r\nmodule.exports = mongoose.model(&quot;Personeller&quot;, new mongoose.Schema({\r\n   Adi: String,\r\n   Soyadi: String,\r\n   Yasi: Number\r\n}));\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"282\" height=\"721\" class=\"aligncenter size-full wp-image-11294\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri.jpg 282w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-117x300.jpg 117w\" sizes=\"auto, (max-width: 282px) 100vw, 282px\" \/><\/a><\/p>\n<p>Evet&#8230; \u015eimdi a\u015fa\u011f\u0131daki operat\u00f6rleri yukar\u0131daki modele kar\u015f\u0131l\u0131k gelen collection \u00fczerinde tek tek inceleyelim;<\/p>\n<ul>\n<li>\n<strong><em>$eq<\/em><\/strong><br \/>\nBelirtilen de\u011fere e\u015fit olan verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $eq: 5 } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-1.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-1.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"286\" height=\"132\" class=\"aligncenter size-full wp-image-11297\" \/><\/a>\n<\/li>\n<li>\n<strong><em>$gt<\/em><\/strong><br \/>\nBelirtilen de\u011ferden b\u00fcy\u00fck olan verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $gt: 30 } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-2.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-2.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"283\" height=\"324\" class=\"aligncenter size-full wp-image-11299\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-2.jpg 283w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-2-262x300.jpg 262w\" sizes=\"auto, (max-width: 283px) 100vw, 283px\" \/><\/a>\n<\/li>\n<li>\n<strong><em>$gte<\/em><\/strong><br \/>\nBelirtilen de\u011ferden b\u00fcy\u00fck veya e\u015fit olan verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $gte: 30 } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<\/li>\n<li>\n<strong><em>$in<\/em><\/strong><br \/>\nBelirtilen birden fazla de\u011ferden herhangi biriyle e\u015fle\u015fen verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $in: &#x5B;31, 40, 26, 50] } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-3.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-3.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"286\" height=\"326\" class=\"aligncenter size-full wp-image-11301\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-3.jpg 286w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-3-263x300.jpg 263w\" sizes=\"auto, (max-width: 286px) 100vw, 286px\" \/><\/a>\n<\/li>\n<li>\n<strong><em>$lt<\/em><\/strong><br \/>\nBelirtilen de\u011ferden k\u00fc\u00e7\u00fck olan verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $lt: 20 } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-4.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-4.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"283\" height=\"229\" class=\"aligncenter size-full wp-image-11302\" \/><\/a>\n<\/li>\n<li>\n<strong><em>$lte<\/em><\/strong><br \/>\nBelirtilen de\u011ferden k\u00fc\u00e7\u00fck veya e\u015fit olan verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $lte: 20 } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<\/li>\n<li>\n<strong><em>$ne<\/em><\/strong><br \/>\nBelirtilen de\u011fere e\u015fit olmayan t\u00fcm verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $ne: 5 } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-5.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-5.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"287\" height=\"624\" class=\"aligncenter size-full wp-image-11304\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-5.jpg 287w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-5-138x300.jpg 138w\" sizes=\"auto, (max-width: 287px) 100vw, 287px\" \/><\/a>\n<\/li>\n<li>\n<strong><em>$nin<\/em><\/strong><br \/>\nBelirtilen birden fazla de\u011ferden hi\u00e7biriyle e\u015fle\u015fmeyen verileri temsil eder.<\/p>\n<pre class=\"brush: jscript; title: ; notranslate\" title=\"\">\r\n      PersonelInstance.find({ Yasi: { $nin: &#x5B;5, 31, 23, 53, 17] } }, (error, data) =&gt; {\r\n         if (error)\r\n            response.send(`Beklenmeyen bir hatayla kar\u015f\u0131la\u015f\u0131ld\u0131. Error : ${error.message}`)\r\n         else\r\n            response.json(data)\r\n      });\r\n<\/pre>\n<p><a href=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-6.jpg\"><img loading=\"lazy\" decoding=\"async\" src=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-6.jpg\" alt=\"MongoDB - Kar\u015f\u0131la\u015ft\u0131rma Sorgu Operat\u00f6rleri\" width=\"279\" height=\"331\" class=\"aligncenter size-full wp-image-11306\" srcset=\"https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-6.jpg 279w, https:\/\/www.gencayyildiz.com\/blog\/wp-content\/uploads\/2019\/06\/MongoDB-Kar\u015f\u0131la\u015ft\u0131rma-Sorgu-Operat\u00f6rleri-6-253x300.jpg 253w\" sizes=\"auto, (max-width: 279px) 100vw, 279px\" \/><\/a>\n<\/li>\n<\/ul>\n<p>\u0130lgilenenlerin faydalanmas\u0131 dile\u011fiyle&#8230;<br \/>\nSonraki yaz\u0131lar\u0131mda g\u00f6r\u00fc\u015fmek \u00fczere&#8230;<br \/>\n\u0130yi \u00e7al\u0131\u015fmalar&#8230;<\/p>\n<!-- AddThis Advanced Settings generic via filter on the_content --><!-- AddThis Share Buttons generic via filter on the_content -->","protected":false},"excerpt":{"rendered":"<p>Merhaba, NoSQL yakla\u015f\u0131m\u0131n\u0131 benimsemi\u015f veritabanlar\u0131ndan biri olan MongoDB&#8217;de sorgu olu\u015ftururken kar\u015f\u0131la\u015ft\u0131rma mant\u0131\u011f\u0131n\u0131 uygulayabilmek i\u00e7in a\u015fa\u011f\u0131daki operat\u00f6rleri kullanabilirsiniz. \u00d6ncelikle \u00f6rneklendirmede kullanaca\u011f\u0131m\u0131z modeli ve veritaban\u0131 i\u00e7erisindeki documentleri a\u015fa\u011f\u0131da ele alal\u0131m; const mongoose = require(&quot;mongoose&quot;); module.exports =&#46;&#46;&#46;<!-- AddThis Advanced Settings generic via filter on get_the_excerpt --><!-- AddThis Share Buttons generic via filter on get_the_excerpt --><\/p>\n","protected":false},"author":1,"featured_media":8971,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2539,2538],"tags":[2902,2903,2904,2905,2906,2907,2908,2909,2534,2533],"class_list":["post-11290","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mongodb","category-nosql","tag-eq-operatoru","tag-gt-operatoru","tag-gte-operatoru","tag-in-operatoru","tag-lt-operatoru","tag-lte-operatoru","tag-ne-operatoru","tag-nin-operatoru","tag-mongodb","tag-nosql"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/11290","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/comments?post=11290"}],"version-history":[{"count":10,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/11290\/revisions"}],"predecessor-version":[{"id":11308,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/posts\/11290\/revisions\/11308"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media\/8971"}],"wp:attachment":[{"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/media?parent=11290"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/categories?post=11290"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gencayyildiz.com\/blog\/wp-json\/wp\/v2\/tags?post=11290"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}