Top "Full-text-search" questions

Full text search involves searching documents, usually involving unstructured text, as opposed to searching text fields in a structured database.

Why does the cardinality of an index in MySQL remain unchanged when I add a new index?

I have added a FULLTEXT index to one of my MySQL database tables as follows: ALTER TABLE members ADD FULLTEXT(…

mysql indexing full-text-search cardinality
Syntax error near 'of' in the full-text search condition 'control of'

I have the following WHERE clause: WHERE (@Keywords IS NULL OR (CONTAINS((p.Title, p.Area, p.[Message]), @Keywords)) ) If @…

sql-server-2008 full-text-search contains
ignoring mysql fulltext stopwords in query

I'm building a search for a site, which utilizes a fulltext search. The search itself works great, that's not my …

mysql full-text-search stop-words
Best way to use PostgreSQL full text search ranking

Following on from this answer I want to know what the best way to use PostgreSQL's built-in full text search …

sql postgresql full-text-search ranking
MySQL Full-text Search Workaround for innoDB tables

I'm designing an internal web application that uses MySQL as its backend database. The integrity of the data is crucial, …

mysql search innodb myisam full-text-search
fuzzy search with lucene

I implemented a fuzzy search with lucene 4.3.1 but i'm not satisfied with the result. I would like to specify a …

lucene full-text-search fuzzy-search
What are some Search Servers out there?

I'm looking to find alternatives to Solr from the Apache Software Foundation. For those that don't know, Solr is an …

search full-text-search search-engine solr
WinSCP: Text search on remote files

I use WinSCP to get access on the remote files of our project. How can I search for some text/…

search full-text-search remote-server winscp
ElasticSearch vs SQL Full Text Search

I want to use full text search in my project... Can anyone explain me, what is the difference between ElasticSearch …

c# .net sql-server full-text-search elasticsearch
How to get a list of StopWords used in my FullText Catalog?

Is there a way to get the StopWord list that my SQL Server 2008 FullText Catalog is using? And use it, …

c# .net sql-server full-text-search stop-words