フレーズと否定を使った$textクエリの実行
引用符付きフレーズ、否定語、複数語の表現を使って$textでクエリを実行し、MongoDBがドキュメントを照合する方法を確認します。
「フレーズと否定を使った$textクエリの実行」はCoddyKit上の無料MongoDB Academyレッスンです。 これはレッスン2/4です。 下記で完全なレッスンを無料で読むことができます。その後、ブラウザ内の組み込みコードエディタと24時間対応のAIチューターでハンズオン演習できます。 これはMongoDB Academy学習パスの一部であり、ウェブとCoddyKitアプリ全体で進捗が同期されます。 MongoDB Academyコースには全4レッスンが含まれています。
このレッスンの一部はまだ翻訳されておらず、英語で表示されています。
The $text Query Operator
Once a text index exists, you run keyword searches with the $text operator inside a find() filter. The value is an object with a $search string containing the words or phrases you are looking for. MongoDB tokenises your search string the same way it tokenised the indexed fields, then returns documents where at least one indexed field contains a matching token.
// Simple keyword search
db.articles.find({ $text: { $search: 'mongodb index' } });
// This returns documents that contain 'mongodb' OR 'index'
// (or their stemmed variants) in any indexed fieldMulti-Word Searches: OR Semantics
By default, a $text search with multiple words uses OR semantics: a document matches if it contains any of the words. So 'mongodb index' returns documents containing 'mongodb' or 'index' or both. The relevance score (textScore) is higher for documents that contain more of the search terms, but all matching documents are returned regardless.
// OR semantics: matches docs with 'mongodb' OR 'index'
db.articles.find(
{ $text: { $search: 'mongodb index' } },
{ score: { $meta: 'textScore' }, title: 1 }
).sort({ score: { $meta: 'textScore' } });
// Documents with BOTH words score higher and appear firstPhrase Searches With Double Quotes
To require an exact phrase, wrap it in escaped double quotes inside the $search string. A phrase search requires the words to appear together and in that order. Documents that only contain some of the phrase words but not the exact sequence will not match. Phrase searches are more precise but can miss relevant documents with slightly different wording.
// Phrase search: 'database index' must appear as a phrase
db.articles.find({
$text: { $search: '"database index"' }
});
// Only matches documents where 'database' and 'index'
// appear together as a phrase, not just anywhere in the text
// Combined phrase and keyword:
db.articles.find({
$text: { $search: '"database index" mongodb' }
});Negation With the Minus Sign
Prefix a word with a minus sign (-) to exclude documents that contain that word. You cannot use negation alone—you must pair it with at least one positive search term. Negation is useful when a keyword is too broad and you want to filter out a specific unwanted meaning, like 'java -coffee' to find programming articles about Java, not the beverage.
// Exclude results containing 'relational'
db.articles.find({
$text: { $search: 'database -relational' }
});
// Find NoSQL content but exclude SQL mentions
db.articles.find({
$text: { $search: 'nosql document store -sql -table' }
});Combining Phrases and Negation
You can freely mix phrases, keywords, and negation in a single $search string. MongoDB processes each term independently: quoted groups are phrase searches, minus-prefixed words are exclusions, and remaining bare words are optional keyword matches. This composability lets you express moderately complex search logic without a dedicated search engine.
// Find articles about 'index tuning' that mention 'mongodb'
// but exclude anything about 'elasticsearch'
db.articles.find({
$text: {
$search: '"index tuning" mongodb -elasticsearch'
}
});Case Insensitivity
$text searches are case-insensitive by default. MongoDB lowercases all tokens during indexing and during the search, so 'MongoDB', 'MONGODB', and 'mongodb' all match the same indexed tokens. You do not need to normalise search input before running a $text query.
// All three queries return the same results
db.articles.find({ $text: { $search: 'MongoDB' } });
db.articles.find({ $text: { $search: 'MONGODB' } });
db.articles.find({ $text: { $search: 'mongodb' } });The $language Option
By default, $text uses the language configured on the text index. You can override this per query with the $language option. This is useful for multilingual content collections where documents stored in different languages should be searched with the appropriate stop word list and stemming algorithm.
// Override language for a specific search
db.articles.find({
$text: {
$search: 'base de datos',
$language: 'spanish'
}
});
// Or disable stop words and stemming entirely
db.articles.find({
$text: {
$search: 'databases',
$language: 'none' // exact token match, no stemming
}
});The $caseSensitive Option
While case-insensitive search is the default, you can enable case-sensitive text search with $caseSensitive: true. This is rarely needed but useful when your content has case-significant identifiers like class names or command names. Note: case-sensitive text search is significantly slower because it cannot use the pre-lowercased index entries.
// Case-sensitive search (slower)
db.docs.find({
$text: {
$search: 'MongoDB',
$caseSensitive: true // 'mongodb' would NOT match
}
});
// Case-insensitive (default, fast)
db.docs.find({
$text: { $search: 'mongodb' } // matches MongoDB, MONGODB, mongodb
});The $diacriticSensitive Option
By default, MongoDB text search is diacritic-insensitive: 'café' and 'cafe' are treated as the same word. You can enable $diacriticSensitive: true to distinguish accented characters. This matters for languages like French, German, or Spanish where diacritics change meaning. Like case sensitivity, diacritic-sensitive search is slower because it bypasses pre-normalised index entries.
// Diacritic-insensitive (default)
db.articles.find({ $text: { $search: 'cafe' } });
// Matches: 'cafe', 'café', 'cáfe'
// Diacritic-sensitive
db.articles.find({
$text: {
$search: 'cafe',
$diacriticSensitive: true
}
});
// Only matches: 'cafe' (not 'café')Text Search in Aggregation Pipelines
You can use $text in aggregation pipelines by placing a $match stage with the text filter as the very first stage. This lets MongoDB push the text search to the index before applying subsequent pipeline stages. You can then project the textScore, group results by category, or limit the number of matches—all server-side.
db.articles.aggregate([
// MUST be the first stage to use the text index
{ $match: { $text: { $search: 'mongodb aggregation' } } },
{ $addFields: { score: { $meta: 'textScore' } } },
{ $sort: { score: -1 } },
{ $limit: 10 },
{ $project: { title: 1, score: 1, category: 1 } }
]);Counting Text Search Results
To count how many documents match a text query, use countDocuments() with the $text filter or add a $count stage at the end of an aggregation pipeline. Avoid using count() (deprecated) and be aware that estimatedDocumentCount() cannot take a filter—always use countDocuments() for filtered counts.
// Count matching documents
const total = await db.articles.countDocuments({
$text: { $search: 'mongodb tutorial' }
});
console.log('Matches:', total);
// In an aggregation pipeline
db.articles.aggregate([
{ $match: { $text: { $search: 'mongodb tutorial' } } },
{ $count: 'total' }
]);Quick Check
Test your understanding of $text query options from this lesson.
Lesson Recap
In this lesson you learned: bare words use OR semantics and match any of the search terms, double-quoted phrases require an exact word sequence, and minus-prefixed words exclude documents containing that term. Next up we sort results by text relevance score using $meta.
よくある質問
「フレーズと否定を使った$textクエリの実行」レッスンは無料ですか?
はい。「フレーズと否定を使った$textクエリの実行」の完全なテキストはこのウェブで無料で読めます。インタラクティブに演習し(組み込みコードエディタと24時間対応のAIチューター)、MongoDB Academyコースの残りをアンロックするには、CoddyKit PROにアップグレードしてください。 MongoDB Academyコースには全4レッスンが含まれています。
「フレーズと否定を使った$textクエリの実行」で何を学びますか?
引用符付きフレーズ、否定語、複数語の表現を使って$textでクエリを実行し、MongoDBがドキュメントを照合する方法を確認します。 ブラウザで直接実行するハンズオンコードでMongoDB Academyを演習し、24時間対応のAIチューターがレッスンを進める中での質問に答えます。
MongoDB Academyを始めるのに経験は必要ですか?
事前経験は必要ありません。CoddyKitのMongoDB Academyは初級者から上級者向けに構成されているため、ここから始めるか最初から始めて、自分のペースで進むことができます。 これはレッスン2/4です。
「フレーズと否定を使った$textクエリの実行」レッスンにはどのくらい時間がかかりますか?
ほとんどのCoddyKitレッスンは約5~10分かかります。各レッスンはコンパクトでインタラクティブなので、着実に進歩し、ウェブとアプリ全体で正確に前回の場所から再開できます。
このMongoDB Academyレッスンでコードを書いて実行できますか?
はい。すべてのMongoDB Academyレッスンに組み込みコードエディタが含まれているため、ブラウザでリアルコードを書いて実行し、即座のAIフィードバックを取得できます。ローカル設定は不要です。
このコースのすべてのレッスン
- 文字列フィールドへのテキストインデックスの作成
- フレーズと否定を使った$textクエリの実行
- $metaによるテキストスコアでのソート
- テキストインデックスの制限とAtlas Searchを使う場面