Search Help (by example)

Syntax:

Literal words: "[search query]" (Includes synonyms)
Exact words: '[search query]' (No synonyms) (Example 2)
Logic - OR: [search query n1], [search query n2], ..., [search query n] (Example 4)
Logic - AND: [search query n1], [search query n2] (Example 5)
Note that all the AND queries and OR queries will be grouped, thus +[q1], [q2], +[q3], +[q4] will end up as WHERE (q1 AND q3 AND q4) OR (q2)
See also example 7.

Example 1

search: stat
explanation: will find anything that matches or partially matches stat
matching keywords: estate professionals, statistic, station yards, statement
remarks: synonyms will be included if any are found in the thesaurus, e.g. a search for management will also search for direction (synonym)
example SQL where clause:
'result' = 'result' and ( lower(subject) like '%stat%')

Example 2

search: "statistics" (double quotes included)
explanation: will find results that contains (i.e. matches) the word statistics, hence no partial matches are made.
matching keywords: summary statistics, test statistics, official statistics, bayesian statistics
remarks: no synonyms are included for this 'literal' search entry

Example 3

search: chain management
explanation: like example 1 it will perform an exact or partial match of the text chain management, hence that includes the space!
matching keywords: supply chain management, supply chain management issues, supply chain management models
remarks: synonyms are included but it's a bit unlikely that many will be found

Example 4

search: chain, management
explanation: it will perform an exact or partial match of the text chain or an exact or partial match on management (a match on both is also included of course)
matching keywords: operations management, supply chains, in supply chain management
remarks: synonyms are included for each comma separated word
example SQL where clause:
'result' = 'result' and ( lower(subject) like '%chain%' or lower(subject) like '%management%')

Example 5

search: +sup, +management
explanation: it will perform an exact or partial match of the text sup AND an exact or partial match on management
matching keywords: supply chain management, purchasing and supply management, marketing management support systems, management support
remarks: synonyms are included for each comma separated word
example SQL where clause:
lower(subject) like '%sup%' and lower(subject) like '%management%'"

Example 6

search: +'support', +'management'
explanation: it will perform an exact match of the text support AND an exact match on management
matching keywords: marketing management support systems, management support, management accounting support
remarks: synonyms are not included for each exact phrase
example SQL where clause:
contains(subject,'support') > 0 and contains(subject,'management') > 0

Example 7

search: +"support", "ict", +man
explanation: it will perform an exact match of the text support AND an exact or partial match on man OR an exact match on the phrase ict
matching keywords: support humans, marketing management support systems, ict applications, ICT
remarks: synonyms are not included for each exact phrase
example SQL where clause:
'result' = 'result' and ( contains(subject,'ict') > 0) or ( contains(subject,'support') > 0 and lower(subject) like '%ok%')