The Expert Search option allows for searching using SQL command structures. The following indexes are utilised:
-ti = Title Keyword Index
The search words must be enclosed in quotes - either single or double.
Example Search Commands:
-ti %Startswith "computer" AND -au %Startswith "gates" AND -kw = "network" OR -kw = "broadband". This will return all records with a Title starting with Computer and Author starting with Gates and contains keywords of network or broadband.
-au LIKE “D%v%%”. This will return Author starting with D followed by one character, followed by v, followed by 2 characters, e.g. David, Davis, Davig
Boolean operators AND, OR, NOT can be used, as well as bracketing. Other standard SQL Operators can also be used, for example:
Between (equivalent to a paired greater than or equal to and less than or equal to)
This allows pattern matching using the following wildcard characters:
_ (underscore) = matches any single character
% = matches any sequence of 0 or more characters
Note: The LIKE comparison operator is case sensitive