o LCAMediabase Help - Searching the database

Searching

This chapter explains how to seach for items in the database



LCAMediabase provides for three search dialogs: Very easy: Browser Style Search

This search screen resembles an Internet Search Engine (like Google) and search results are presented in a similar fashion. This search mode is also available as a separate application.

Moderately easy:

Press Ctrl-F or select Search->Search Items to display this dialog.
The first search option specifies where to search: Boolean Full-Text search: (only with MySQL databases)

The boolean full-text search capability supports the following operators:

+ A leading plus sign indicates that this word must be present in every row returned.
- A leading minus sign indicates that this word must not be present in any row returned.
< > These two operators are used to change a word's contribution to the relevance value that is assigned to a row. The < operator decreases the contribution and the > operator increases it.
( ) Parentheses are used to group words into subexpressions.
~ A leading tilde acts as a negation operator, causing the word's contribution to the row relevance to be negative. It's useful for marking noise words. A row that contains such a word will be rated lower than others, but will not be excluded altogether, as it would be with the - operator.
* An asterisk is the truncation operator. Unlike the other operators, it should be appended to the word, not prepended.
" The phrase, that is enclosed in double quotes ", matches only rows that contain this phrase literally, as it was typed.

Note: if you cannot find some words: Some common words are in the MySQL's so-called 'stopword file' and these words are not included in the search index and cannot be found. Use the MySQLAdministrator application to change the server settings to use a different stopword file or no stopword file at all. Also please take note of the 'min_word_length' server variable.

Advanced:


Back to Top | Getting started | Home | Help on the Web