Help:Full-text search/Searching

In addition to the regular combination of tildes (~) and asterisk (*) wildcards, as explained elsewhere on this wiki the full text search also offers some additional features and helps to overcome the native limitations of datatype "Text".

Examples
Annotation to a property called "Has text" of CiteRef::sb:smw:1481

Has text::... The principles of definition, the law of contradiction, the fallacy of arguing in a circle, the distinction between the essence and accidents of a thing or notion, between means and ends, between causes and conditions; also the division of the mind into the rational, concupiscent, and irascible elements, or of pleasures and desires into necessary and unnecessary --these and other great forms of thought are all of them to be found in the Republic, and were probably first invented by Plato. The greatest of all logical truths, and the one of which writers on philosophy are most apt to lose sight, the difference between words and things, has been most strenuously insisted on by him, although he has not always avoided the confusion of them in his own writings. ...

Phrase matching (both uppercase and lowercase)
Phrase matching is done by putting double quotes on either side of the phrase ("..."). This works for both uppercase and lowercase characters.

Query:

Result:

Approximate matching within long texts
If the property is unknown, use two tildes instead of one:

Query:

Result:

Wide proximity
Broad text search tries to match a string text without a specific property to broaden possible result matches. To initiate a fulltext match search specific an additional  will indicate to the   to use the fulltext index.


 * to be translated into the SQL-query
 * to be translated into the SQL-query

Search highlighting
Search highlightingCiteRef::gh:smw:2253 which is done by adding the  formatter to the printout statement of the respective property.

Query:

Result:

More examples

 * A collection of examples is available from the Sandbox site.