Stack Overflow
Stack Overflow

Questions tagged [full-text-search]

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

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

Full text search capabilities often include ranking of results by relevance, similarity matching, boolean queries, text clustering, and more.

Popular Full-text Search Tags

Popular Full-text Search Tags related to Open Source solutions.

7909 questions
3
votes
1 answer

SQL Server full-text search with prefix and noise word

I do not understand why following Query1 and Query2 don't return similar result sets. Samples Query1: select * from dbo.tFTS_test where contains (*, '"qwe-asd*"') Returns: Id Value ----------- ---------- (0 row(s)…
GriGrim
  • 2,891
  • 1
  • 19
  • 33
3
votes
1 answer

Why is my query so slow? (SQL Server 2008 full text search weirdness)

I have a table with a full-text indexed column MiddlePart. The table has around 600,000 rows. The following query is very fast (30 results, <1 second): select * from DomainName where contains (MiddlePart, '"antiques*"') OR freetext(MiddlePart,…
Nathan Ridley
  • 33,766
  • 35
  • 123
  • 197
3
votes
2 answers

MySQL: how to make multiple table fulltext search

I want to integrate the MySQL fulltext search function in my PHP site. I have the following problem now. SELECT * FROM testtable t1, testtable2 t2 WHERE MATCH ( t1.firstName, t1.lastName, t1.details, t2.firstName, t2.lastName, t2.details ) AGAINST…
SUN Jiangong
  • 5,242
  • 16
  • 57
  • 76
3
votes
3 answers

Object could not be found in database for SearchResult django haystack

I am using haystack with elasticsearch. I have build index data using rebuild_index command. But when I tried to search for object, its giving me following error: "Object could not be found in database for SearchResult ' (pk=u'118')>'." I have…
Nikhil N
  • 4,507
  • 1
  • 35
  • 53
3
votes
2 answers

TSQL: query with optional join

I have a search ui with 3 all optional search criteria. 2 of them are simple criteria for a where statement, that I should be able to solve with this: Stored Procedure with optional "WHERE" parameters. The last criterion is using full text search…
Karsten
  • 8,015
  • 8
  • 48
  • 83
3
votes
3 answers

Database design for Wave-like collaboration system

How do we decide what the smallest unit is? For text collaboration should it be a word, a paragraph? Is there going to be performance issues if the unit is too small? But it might be more flexible
Jan
  • 165
  • 2
  • 6
3
votes
1 answer

MySQL full-text search in Rails?

When I added search functionality to my first Rails app, I used Sphinx, after reading that using MySQL's built-in fulltext search was a bad idea. While Sphinx works well, it's a bit complicated to set up, and I feel there's too much overload for the…
igul222
  • 8,557
  • 14
  • 52
  • 60
3
votes
2 answers

How do I perform a MOSS FullTextSqlQuery and filter people results by the Skills managed property?

I am having trouble with a MOSS FulltextSqlQuery when attempting to filter People results on the Skills Managed Property using the CONTAINS predicate. Let me demonstrate: A query with no filters returns the expected result: SELECT AccountName,…
Trent
  • 560
  • 4
  • 11
3
votes
3 answers

Stemming does not work properly for MongoDB text index

I am trying to use full text search feature of MongoDB and observing some unexpected behavior. The problem is related to "stemming" aspect of the text indexing feature. The way full text search is described in many articles online, if you have a…
Michael Smolyak
  • 593
  • 2
  • 6
  • 21
3
votes
2 answers

How to make MySQL treat underscore as a word separator for fulltext search?

I am using MySQL fulltext and PHP (codeigniter) to search a database containing RSS items. Problem is some of these items's titles use underscores instead of spaces. Since MySQL considers underscores as part of a word, these items will never be…
deadelvis
  • 181
  • 1
  • 8
3
votes
2 answers

Is there a list of most common english words for indexing text for search?

Is there a free available list of the most common english words to remove from text for creating a search index?
Dave
  • 41
  • 2
3
votes
3 answers

In Solr, How to query against one field for distinct set of values in a multi-valued field

I basically want Solr to search each record of the multivalued field for my search parameter.. read on for my example: I am using Solr to index my data. I have application data in parallel arrays (in the form of multi-valued fields) that match a…
Dan
  • 555
  • 3
  • 11
  • 16
3
votes
2 answers

Appropriate datastructure for key.contains(x) Map/Dictionary

I am somewhat struggling with the terminology and complexity of my explanations here, feel free to edit it. I have 1.000 - 20.000 objects. Each one can contain several name words (first, second, middle, last, title...) and normalized numbers(home,…
ASA
  • 1,911
  • 3
  • 20
  • 37
3
votes
1 answer

SQL 2008 Full Text Search Catalog on multiple tables

I am attempting to setup a full text search catalog in SQL Server 2008 is there a way to make this catalog contain data from multiple tables?
dswatik
  • 9,129
  • 10
  • 38
  • 53
3
votes
2 answers

XQuery Full text searching over mixed content

Following is the XML structure - (i have given a very small piece of the entire document with limited data. I have a XML DB of 6 GB, with proper FULL TEXT Index.) No - 1 departmental…
John
  • 2,820
  • 3
  • 30
  • 50
1 2 3
…
99 100