官术网_书友最值得收藏!

Full-text search

Sphinx is a full-text search engine. So, before going any further, we need to understand what full-text search is and how it excels over the traditional searching.

What is full-text search?

Full-text search is one of the techniques for searching a document or database stored on a computer. While searching, the search engine goes through and examines all of the words stored in the document and tries to match the search query against those words. A complete examination of all the words (text) stored in the document is undertaken and hence it is called a full-text search.

Full-text search excels in searching large volumes of unstructured text quickly and effectively. It returns pages based on how well they match the user's query.

Traditional search

To understand the difference between a normal search and full-text search, let's take an example of a MySQL database table and perform searches on it.

It is assumed that MySQL Server and phpMyAdmin are already installed on your system.

主站蜘蛛池模板: 大同市| 海兴县| 莆田市| 临夏县| 河间市| 来宾市| 台州市| 常州市| 会泽县| 梅州市| 五寨县| 柞水县| 东丽区| 思南县| 遵化市| 南通市| 临湘市| 张北县| 安化县| 师宗县| 拉萨市| 宝鸡市| 哈巴河县| 新邵县| 米林县| 乌兰县| 宝清县| 文登市| 乐平市| 岑巩县| 西丰县| 福鼎市| 武城县| 营山县| 临城县| 左云县| 蓝田县| 兴安县| 谷城县| 建瓯市| 武清区|