The words do not need to be specified in any particular order. Select the title of movies whose description contains the words 'century' and 'life'. By default character case is ignored. Hence in the previous query the word 'century' matched with 'Century' in the actual description field. Select the title of movies whose description contains the word 'Life' in that exact character case.
Phrase searches locate a sequence of adjacent words in a specific order.
Phrases are specified by enclosing words within double quotes. Find the movieno and title of movies whose description matches the stem of the word ' village'. Phonetic searches provide a method of matching words which sound similar and is typically useful for matching variations of person or place names. Find the title and director of the movie whose director has a name sounding like 'milar'. Find the title of movies whose description does not contain the word 'life'.