Searching FAQ

Click on the "Search" button.

The Search Interface

1. The Screen

The Search button at the top of the screen will only return you to this same screen. All the necessary instructions and clicks to perform a search of the database are input within the graphic box which is headed "Enter a list of words separated by spaces."

2. Searching

In the text input area you can either enter one or more search terms (separated by spaces) or an asterisk (*).

If you enter an asterisk (*) the search will retrieve all records in the database and return them to the screen in the display mode you have selected (see below).

The search engine will return to the screen all records containing either part or all of your search term or terms (for example, the search term "old" will return all records that contain the word "old" or that contain words (such as "holdings") that contain the string "old" within them.



If you check the Case Sensitive checkbox, the search engine will return to you only those records containing your search term or terms in the exact cases in which you input them into the text input area

If you check the Match All Words checkbox, the search engine will return to you only those records containing the exact term or terms you entered into the text input area. For example, a Match All Words search on the term "old" would not return records containing only words of which the string "old" was a part, such as "holding." You would get only those records with the word "old" in them.

The Number of Records to display checkbox is checked for the default value, and most users will not need to concern themselves with it.

If you check the Sort by Date of Insertion checkbox, your retrieval results will be sorted according to the date on which the records were entered into the BooksCatalog database.




Searching Techniques




OPERATOR TO USE


=      equals for strings (search matches exact string input as keyword)

=^      begin with for strings (search retrieves strings beginning with the keyword)

=~      contains for strings (search retrieves strings containing the keyword)

!=      not equal for strings (search retrieves strings NOT containing the keyword)

!^      do not begin with for strings (search retrieves only strings NOT beginning with the keyword)

!~      do not contain for strings (search retrieves only strings NOT containing the keyword)

==      equals for numbers (search matches the input number keyword)

<>      not equal for numbers

<, >, < =, > =      for numbers (less than; greater than; less than or equal to; greater than or equal to)



EXAMPLES

keyword: title=[complete title string] returns every record with the input string in the title field

keyword imprint=^aug returns every record whose imprint field contains the string aug

keyword mainentry=~Bi returns every record with the input string in the main entry field (Bible, Bierce, etc.)

keyword imprint>1934 returns every record with a date or a number greater than 1934 in its imprint field


MIXING OPERATORS:

title=^Bi imprint>1955 subjects = juvenile returns every record whose title field begins with the string Bi published after 1955 with the word juvenile in its subjects field