Close this window

Using the simple search form

While the simple search form only searches on last names, you can narrow your searches using these signs:

+   A leading plus sign indicates that this word must be present in every record returned.

-    A leading minus sign indicates that this word must not be present in any record returned.

*   An asterisk is put in place of a letter or series of letters to search by the first part of a word. It can only replace letter(s) at the end of a word. The * can be used with the + and - signs

"  "    Double quotes at the beginning and end of a phrase, matches only records that contain the complete phrase, as it was typed.

Examples of searches

apple banana   --> Find all records that contain at least one of the two words. Each resulting record will all have at least one of the two words in it.

+apple +juice   --> Find all records that contain both words. Each resulting record will include both words.

+apple -macintosh   --> Find records that contain the word "apple'' but not "macintosh''.

apple*   --> Find records that contain words such as "apple'', "apples'', "applesauce'', or "applet''.
ap*       --> Find records that contain any of the above plus "apply", "apocalypse", "apt".

"some words"   --> Find all records that contain the exact phrase "some words'' (for example, records that contain "some words of wisdom'' but not "some noise words'').

(From the MySQL Manual)

Close this window