History: Search MySQL Advanced

            ! Advanced Search or Boolean Search

This is deprecated (and will be removed), because it has been superceded by ((Unified Index)) in ((Tiki7)).

To use, visit tiki-searchresults.php and click the "Advanced search" check box.


^
__Default search behavior__

By default, all search terms are optional. It behaves like an OR logic. Objects that contain the more terms are rated higher in the results and will appear first in their type. For example, __wiki forum__ will find:

objects that include both terms
objects that include the term __wiki__
objects that include the term __forum__

__Requiring terms__

Add a plus sign ( + ) before a term to indicate that the term must appear in results. Example: __+wiki forum__ will find objects containing at least __wiki__. Objects with both terms and many occurences of the terms will appear first.

__Excluding terms__

Add a minus sign ( - ) before a term to indicate that the term must not appear in the results. To reduce a term's value without completely excluding it, use a tilde. Example: __-wiki forum__ will find objects that do not contain __wiki__ but contain __forum__

__Grouping terms__

Use parenthesis ( ) to group terms into subexpressions. Example: __+wiki +(forum blog)__ will find objects that contain __wiki__ and __forum__ or that contain __wiki__ and __blog__ in any order.

__Finding phrases__

Use double quotes ( " " ) around a phrase to find terms in the exact order, exactly as typed. Example: "__Alex Bell__" will not find __Bell Alex__ or __Alex G. Bell__.

__Using wildcards__

Add an asterisk ( * ) after a term to find objects that include the root word. For example, __run*__ will find:

objects that include the term __run__
objects that include the term __runner__
objects that include the term __running__

__Reducing a term's value__

Add a tilde ( ~ ) before a term to reduce its value indicate to the ranking of the results. Objects that contain the term will appear lower than other objects (unlike the minus sign which will completely exclude a term). Example: __+wiki ~forum__ will rate an object with only __wiki__ higher that an object with __wiki__ and __forum__.

__Changing relevance value__

Add a less than ( < ) or greater than ( > ) sign before a term to change the term's contribution to the overall relevance value assigned to a object. Example: __+wiki +(>forum < blog)__ will find objects that contain __wiki__ and __forum__ or __wiki__ and __blog__ in any order. __wiki forum__ will be rated higher.
^