Full-Text Search

With full text search facility tune down the comprehensiveness for better relevant results.



Setting up a comprehensive knowledge base is the key to increased customer satisfaction and improved productivity. For instance, if a knowledge base is created with motive to provide customer service representatives with solutions to the most common issues, so they can assist customers quickly then, the search facility of the knowledge base should be incredibly fast.

PHPKB knowledge base software has powerful & accurate search engine that can search thousands of articles. It can search among categories, articles, news, attachment files, and custom-fields. Each article in the search results is ranked based on its relevance, i.e. most relevant articles are displayed at the top of search results. The relevance value is an approximation of how close the article is to the search criteria. The value is calculated by the full text search engine which uses a complex algorithm to determine article relevance. For example, words that appear near the beginning of a document are more relevant than the same words appearing towards the end of the document.

Benefits of Full-text Search

Full-text search involves indexing the individual words within a field to make searching through many records quick and precise. Full-text indexes can offer a lot more flexibility in terms of the order of matching words, how close those words are together, etc.


A full-text search can stem words. If you search for "run", you can get results for "ran" or "running". Most full-text engines have stem dictionaries in a variety of languages.

Weighted Results:

A full-text index can encompass multiple columns. For example, you search for "changing nameservers", and the index can include a title, keywords, and a body. Results that match the title can be weighted higher, as more relevant, and can be sorted to show near the top.

Full-text Types Supported in MySQL Editions

Full-text Search Types in MySQL

  • In Natural Language Mode: A natural language search interprets the search string as a phrase in natural human language (a phrase in free text). There are no special operators. The stopword list applies. In addition, words that are present in 50% or more of the rows are considered common and do not match. Full-text searches are natural language searches if no modifier is given.
  • In Boolean Mode: A boolean search interprets the search string using the rules of a special query language. The string contains the words to search for. It can also contain operators like "+", "-" etc that specify requirements such that a word must be present or absent in matching rows, or that it should be weighted higher or lower than usual. Common words such as "some" or "then" are stopwords and do not match if present in the search string. The IN BOOLEAN MODE modifier specifies a boolean search.
  • With Query Expansion: A query expansion search is a modification of a natural language search. The search string is used to perform a natural language search. Then words from the most relevant rows returned by the search are added to the search string and the search is done again. The query returns the rows from the second search. The WITH QUERY EXPANSION modifier specifies a query expansion search.
Full-text Types Supported in MS SQL Server Editions

Full-text Search Types in MSSQL

  • Simple: In simple full-text search, a word (or token) is a string whose boundaries are identified by appropriate word breakers, following the linguistic rules of the specified language. A valid phrase consists of multiple words, with or without any punctuation marks between them. For example, "croissant" is a word, and "cafĂ© au lait" is a phrase. Words and phrases such as these are called simple terms.
  • Inflectional: The inflectional forms are the different tenses and conjugations of a verb or the singular and plural forms of a noun. For example, search for the inflectional form of the word "drive". If various rows in the table include the words "drive", "drives", "drove", "driving", and "driven", all would be in the result set because each of these can be inflectionally generated from the word drive.
  • Thesaurus: A thesaurus defines user-specified synonyms for terms. For example, if an entry, "{car, automobile, truck, van}", is added to a thesaurus, you can search for the thesaurus form of the word "car". All rows in the table queried that include the words "automobile", "truck", "van", or "car", appear in the result set because each of these words belong to the synonym expansion set containing the word "car".
What it searches

If you did not specify any search options, the search functionality examines the following:

  • Article: title, content, keywords
  • Category: name, description
  • News: title, content
  • File: file name, caption

Get It Now

Whether you are looking for an in-house solution OR a cloud-hosted knowledge management tool, PHPKB knowledge base software offers enterprise-class features with pricing that can fit a small business budget.

Purchase Now
Trusted by successful businesses around the globe

Some of the world's best companies proudly use PHPKB knowledge management software.


Try it yourself 30 days free

Get a fully functional 30-day free trial.
Our knowledge base software is easy to use and backed by awesome support.

Get Started