Home arrow Current Vacancies arrow How Boolean Searches Work
How Boolean Text Searches Work Print E-mail
The boolean full-text search capability supports the following operators:

OPERATOR DESCRIPTION
+ A leading plus sign indicates that this word must be present in each result that is returned. i.e. It stands for AND
-
 A leading minus sign indicates that this word must not be present in any of the results that are returned. i.e. It stands for NOT
(no operator)
 When neither + nor - is specified this implies the word is optional. i.e. it implies OR
* The asterisk serves as the truncation (or wildcard) operator. Unlike the other operators, it should be appended to the word to be affected. Words match if they begin with the word preceding the * operator.
 "
 A phrase that is enclosed within double quote (“"”) characters matches only results that contain the phrase exactly, as it was typed.


The following examples demonstrate some search strings that use boolean full-text operators:

apple banana
Finds results that contain at least one of the two words.

+apple +juice
Finds results that contain both words.

+apple macintosh
Finds results that contain the word “apple”, but rank rows higher if they also contain “macintosh”.

+apple -macintosh
Find rows that contain the word “apple” but not “macintosh”.

apple*
Finds results that contain words such as “apple”, “apples”, “applesauce”, or “applet”.

"some words"
Finds results that contain the exact phrase “some words” (for example, rows that contain “some words of wisdom” but not “some noise words”).

 
 
[ Back ]
RecruiterAwardsLogo.png

Newsflash

UK based semiconductor vendor, Icera says that it is the first baseband chipset company to demonstrate a dual mode LTE / HSPA modem running on a commercial USB data stick.

 
Free Joomla Templates by JoomlaShine.com