{"id":2760,"date":"2023-07-20T20:12:22","date_gmt":"2023-07-20T20:12:22","guid":{"rendered":"https:\/\/statorials.org\/tr\/mongodb-veya\/"},"modified":"2023-07-20T20:12:22","modified_gmt":"2023-07-20T20:12:22","slug":"mongodb-veya","status":"publish","type":"post","link":"https:\/\/statorials.org\/tr\/mongodb-veya\/","title":{"rendered":"Mongodb: sorgularda or operat\u00f6r\u00fc ($or) nas\u0131l kullan\u0131l\u0131r?"},"content":{"rendered":"

<\/p>\n

\n

Birden fazla kriterden herhangi biriyle e\u015fle\u015fen belgeleri bulmak i\u00e7in MongoDB’de $or<\/strong> operat\u00f6r\u00fcn\u00fc kullanabilirsiniz.<\/span><\/p>\n

Bu operat\u00f6r a\u015fa\u011f\u0131daki temel s\u00f6zdizimini kullan\u0131r:<\/span><\/p>\n

 db.myCollection.find({\n  \u201c $or<\/span> \u201d: [\n    {\" field1<\/span> \": \" hello<\/span> \"},\n    {\" field2<\/span> \": { $gte<\/span> : 10<\/span> }}\n  ]\n})<\/strong><\/pre>\n
 Bu \u00f6zel \u00f6rnek, alan1’in<\/strong> “merhaba”ya e\u015fit oldu\u011fu veya<\/em> alan2’nin<\/strong> 10’dan b\u00fcy\u00fck veya ona e\u015fit bir de\u011fere sahip oldu\u011fu myCollection<\/span> adl\u0131 koleksiyondaki t\u00fcm belgeleri arar.<\/span><\/p>\n
 A\u015fa\u011f\u0131daki \u00f6rnekler, bu s\u00f6zdiziminin , a\u015fa\u011f\u0131daki belgelere sahip<\/span> bir koleksiyon ekibiyle<\/span> pratikte nas\u0131l kullan\u0131laca\u011f\u0131n\u0131 g\u00f6sterir<\/span> :<\/p>\n
 db.teams.insertOne({team: \" Mavs<\/span> \", points: 30, rebounds: 8})\ndb.teams.insertOne({team: \" Mavs<\/span> \", points: 35, rebounds: 12})\ndb.teams.insertOne({team: \" Spurs<\/span> \", points: 20, rebounds: 7})\ndb.teams.insertOne({team: \" Spurs<\/span> \", points: 25, rebounds: 5})\ndb.teams.insertOne({team: \" Spurs<\/span> \", points: 23, rebounds: 9})<\/strong><\/pre>\n
 \u00d6rnek 1: OR operat\u00f6r\u00fcn\u00fc iki alanla kullanma<\/strong><\/span><\/h3>\n
 A\u015fa\u011f\u0131daki kod, “tak\u0131m” alan\u0131n\u0131n “Spurs”a e\u015fit oldu\u011fu veya<\/em> “puan” alan\u0131n\u0131n de\u011ferinin 31’den b\u00fcy\u00fck veya e\u015fit oldu\u011fu tak\u0131m<\/span> koleksiyonundaki t\u00fcm belgelerin nas\u0131l bulunaca\u011f\u0131n\u0131 g\u00f6sterir:<\/span><\/p>\n
 db.teams.find({\n  \u201c $or<\/span> \u201d: [\n    {\" team<\/span> \": \" Spurs<\/span> \"},\n    {\" points<\/span> \": { $gte<\/span> : 31<\/span> }}\n  ]\n})<\/strong><\/pre>\n
 Bu sorgu a\u015fa\u011f\u0131daki belgeleri d\u00f6nd\u00fcr\u00fcr:<\/span><\/p>\n
 { _id: ObjectId(\"62018750fd435937399d6b6f\"),\n  team: 'Mavs',\n  points: 35,\n  rebounds: 12 }\n{ _id: ObjectId(\"62018750fd435937399d6b70\"),\n  team: 'Spurs',\n  points: 20,\n  rebounds: 7 }\n{ _id: ObjectId(\"62018750fd435937399d6b71\"),\n  team: 'Spurs',\n  points: 25,\n  rebounds: 5 }\n{ _id: ObjectId(\"62018750fd435937399d6b72\"),\n  team: 'Spurs',\n  points: 23,\n  rebounds: 9 }<\/strong><\/pre>\n
 \u00c7\u0131kt\u0131daki her belgenin tak\u0131m alan\u0131nda “Spurs” veya<\/em> puan alan\u0131nda 31’den b\u00fcy\u00fck veya ona e\u015fit bir de\u011fer i\u00e7erdi\u011fini unutmay\u0131n.<\/span><\/p>\n
 \u00d6rnek 2: OR operat\u00f6r\u00fcn\u00fc ikiden fazla alanla kullanma<\/strong><\/span><\/h3>\n
 A\u015fa\u011f\u0131daki kod, “tak\u0131m” alan\u0131n\u0131n “Mavs”e e\u015fit oldu\u011fu veya<\/em> “puan” alan\u0131n\u0131n de\u011ferinin 25’ten b\u00fcy\u00fck veya ona e\u015fit oldu\u011fu veya<\/em> “ribaund” alan\u0131n\u0131n de\u011ferinin oldu\u011fu tak\u0131mlar<\/span> koleksiyonundaki t\u00fcm belgelerin nas\u0131l bulunaca\u011f\u0131n\u0131 g\u00f6sterir. 8’den k\u00fc\u00e7\u00fck:<\/span><\/p>\n
 db.teams.find({\n  \u201c $or<\/span> \u201d: [\n    {\" team<\/span> \": \" Mavs<\/span> \"},\n    {\" points<\/span> \": { $gte<\/span> : 25<\/span> }},\n    {\" rebounds<\/span> \": { $lt<\/span> : 8<\/span> }}\n  ]\n})<\/strong><\/pre>\n
 Bu sorgu a\u015fa\u011f\u0131daki belgeyi d\u00f6nd\u00fcr\u00fcr:<\/span><\/p>\n
 { _id: ObjectId(\"62018750fd435937399d6b6e\"),\n  team: 'Mavs',\n  points: 30,\n  rebounds: 8 }\n{ _id: ObjectId(\"62018750fd435937399d6b6f\"),\n  team: 'Mavs',\n  points: 35,\n  rebounds: 12 }\n{ _id: ObjectId(\"62018750fd435937399d6b70\"),\n  team: 'Spurs',\n  points: 20,\n  rebounds: 7 }\n{ _id: ObjectId(\"62018750fd435937399d6b71\"),\n  team: 'Spurs',\n  points: 25,\n  rebounds: 5 }\n<\/strong><\/pre>\n
 Bu belgelerin her birinin \u00fc\u00e7 kriterden birini veya daha fazlas\u0131n\u0131 kar\u015f\u0131lad\u0131\u011f\u0131n\u0131 unutmay\u0131n:<\/span><\/p>\n