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

How can I know when SQL Server Full Text Search has indexed a record?

My question is similar to this one: How can I know when SQL Full Text Index Population is finished? only instead of population status of the whole index I need to know if SQL Server Full Text Search (FTS) has already indexed certain record in the…
Sergey Tarasov
  • 858
  • 11
  • 18
3
votes
1 answer

Full text search syntax error

I created a full text search with a catalog and index and the contains query works fine when I run a query with one word like below. SELECT Name FROM dbo.Gifts WHERE CONTAINS(Name, 'gift') it returns 'test gift' I have only one row in the table and…
chuckd
  • 13,460
  • 29
  • 152
  • 331
3
votes
3 answers

Sqlite FTS exact word

SELECT * FROM my_table WHERE product MATCH "apple"; returns: apple, green apple, apple jam ... I need FTS query that returns only "apple". These work slow: SELECT * FROM my_table WHERE product="apple"; SELECT * FROM my_table WHERE product LIKE…
user171435
  • 41
  • 1
  • 3
3
votes
1 answer

Sunspot conjunction and disjunctions not working

I'm getting this error NoMethodError: undefined method 'any' for # when I try to do like as per documentation. https://github.com/sunspot/sunspot#disjunctions-and-conjunctions Post.search do any do …
Data Don
  • 338
  • 2
  • 11
3
votes
1 answer

Short circuiting in sql server with full text search predicates

I am a novice in t-sql and sql server, and I have a question about short circuiting and full text search. Let's assume I have a statement like this: SELECT * FROM t1 LEFT JOIN t2 ON t1.Id = t2.Id WHERE contains(t1.Field1,@word) or…
luckyfish
  • 31
  • 6
3
votes
1 answer

Mysql german accents not-sensitive search in full-text searches

Let`s have a example hotels table: CREATE TABLE `hotels` ( `HotelNo` varchar(4) character set latin1 NOT NULL default '0000', `Hotel` varchar(80) character set latin1 NOT NULL default '', `City` varchar(100) character set latin1 default NULL, …
denesis
  • 73
  • 5
3
votes
0 answers

Multi Tenancy with Full Text Search

I am trying to implement Full Text Search in a SQL View which is supporting Multi Tenancy Implementation using TenantID Filter to retrieve data from the underlying table. Eg: Table Name - BOOKS which is having a TENANT_ID Column View Name -…
Arun662469
  • 97
  • 7
3
votes
1 answer

Progressive search for longest prefix

I have a table with phone number prefix columns like: prefix ------ 9379 355422 35566 ... Given a phone number I want to drop its digits starting from the right until It finds the first match on the prefix column.…
Marconi
  • 3,601
  • 4
  • 46
  • 72
3
votes
0 answers

search content inside files stored in blob fields

The database of my application stores files in a FILESTRAM blob field. I have a dedicated table where i keep all files. THis is the table (DOCUMENT is the blob field): CREATE TABLE [dbo].[DOC_FILES]( [ID_DOC_FILE] [int] NOT NULL, [DOCUMENT]…
UnDiUdin
  • 14,924
  • 39
  • 151
  • 249
3
votes
7 answers

Does grep work properly on pdf files?

Is it possible to search multiple pdf files using the 'grep' command. It doesn't seem to work, how do people search content on multiple pdf files?
Sam
  • 8,387
  • 19
  • 62
  • 97
3
votes
1 answer

Cannot create noindexed columns with in sqlite FTS table

I'm trying to create the following table with sqlite 3.8.2 CREATE VIRTUAL TABLE IF NOT EXISTS media_fts USING fts4 ( notindexed=media_id, notindexed=album_id, title, artist, …
Name is carl
  • 5,961
  • 3
  • 29
  • 44
3
votes
2 answers

Solr (sunspot) not finding partial word match when suffix included

I'm implementing solr into a Rails app, specifically pertaining to ingredient searches. If I do a partial word match on a simple noun like "beef" or "chicken", I can type in any number of letters from 1 to the full string, and it finds ingredients…
Matt Huggins
  • 81,398
  • 36
  • 149
  • 218
3
votes
1 answer

What's a good database for full text search on a large number of relatively small text documents? (C# backend)

I am designing a system that aims to ingest large numbers of documents. I want to support full text search on the document contents, as well as other metadata (keyword/sentiment analysis). How keyword/sentiment analysis is done is beyond the scope…
jCuga
  • 1,523
  • 3
  • 16
  • 28
3
votes
2 answers

Poor execution plans when using a filter and CONTAINSTABLE in a query

We have an interesting problem that I was hoping someone could help to shed some light on. At a high level the problem is as below: The following query executes quickly (1 second): SELECT SA.* FROM cg.SEARCHSERVER_ACTYS AS SA JOIN…
Paul McLoughlin
  • 2,283
  • 1
  • 15
  • 15
3
votes
0 answers

ElasticSearch: TooManyClauses exception when adding highlight

My query_string query gives me a TooManyClauses exception. However, in my case I don't think that the exception is thrown due to the usual reason. Instead, it seems to be related to highlighting, because when I remove the highlight from the query,…
Markos Fragkakis
  • 7,499
  • 18
  • 65
  • 103
1 2 3
…
99 100