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

Understanding implementation of DC3/Skew algorithm to create Suffix Array linear time

I am trying to understand implementation of linear time suffix array creation algorithm by Karkkainen, P. Sanders. Details of algorithm can be found here. I managed to understand overall concept but failing to match it with provided implementation…
Devendra Wani
  • 121
  • 2
  • 9
3
votes
2 answers

How do I perform a SQL Server fulltext CONTAINS search for 'C#'

In SQL Server 2008 R2, I'm doing a full-text search for the term 'C#' like this: SELECT * FROM Book b WHERE CONTAINS (b.title , 'c#') However, the full text search looks like it strips out the pound sign and then performs the search. If I do a…
Trevor
  • 4,620
  • 2
  • 28
  • 37
3
votes
1 answer

Mongoose, nodejs, full text search

I am trying setting up a simple keywords full text search using Mongoose and nodejs, this is the code so far: var db = mongoose.createConnection('localhost', config.mongoDbName) , ContSchema = Schema({ 'idUser': String, 'title':…
itsme
  • 48,972
  • 96
  • 224
  • 345
3
votes
2 answers

elasticsearch: phrase search for two adjacent words in any order (analyzed)

The problem is to do a phrase search for two adjacent words in any order with words analysis. E.g. in Sphinx extended syntax terms the query string can be written as WordToBeAnalyzed1 NEAR/1 WordToBeAnalyzed2. Then both words are being analyzed and…
Sergii Golubev
  • 398
  • 3
  • 11
3
votes
2 answers

mysql full text search ampersand (&) Problem

How can I serach word with "&" using mysql full text search ? There are words string, like "Marks & Spencer", "at&t" in my tables , serach "at&t", but can't find it on the database using mysql full text search Any ways to serach word with "&"?
Jason
  • 363
  • 1
  • 8
  • 19
3
votes
4 answers

fulltext index returning no results from pdf filestream

I have a filestream table running on SQL Server 2012 on a Windows 8.1 x64 machine, which already have a few PDF and TXT files stored, so I decided to create a fulltext index to search through these files by using the following command: CREATE…
leandro koiti
  • 423
  • 1
  • 7
  • 18
3
votes
3 answers

Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?

There is a request to make the SO search default to an AND style functionality over the current OR when multiple terms are used. The official response was: not as simple as it sounds; we use SQL Server 2005's FREETEXT() function, and I can't find a…
Chris
  • 6,761
  • 6
  • 52
  • 67
3
votes
2 answers

Using a hyphen in fulltext search with an InnoDB engine?

I have a FULLTEXT search in a table of part numbers. Some part numbers have hyphens. The table engine is InnoDB using MySQL 5.6. The problem I am having is that MySQL was treating the hyphen (-) character as a word separator. So I created a new…
Anthony
  • 648
  • 1
  • 7
  • 22
3
votes
1 answer

Extracting person names from a free-form text field

I have a large table of 30 million records that contains a free-form text field which may contain names in any position and with any salutation, or not salutation at all. My job is to mask out the names with Xxxxx Xxxxx to preserve privacy. I have…
user3553088
  • 41
  • 2
3
votes
1 answer

Recommended way to perform Lucene search without limit

The Lucene documents tell me that "Hits" will be removed from the API in Lucene 3.0. Deprecated. Hits will be removed in Lucene 3.0. Use search(Query, Filter, int) instead. The proposed overload limits the number of documents returned to the…
Thomas
  • 7,933
  • 4
  • 37
  • 45
3
votes
1 answer

Searching through user favorites with Elasticsearch

We're using Elasticsearch to index about 100,000 documents. Users can favorite items and currently we're using Django Haystack's RelatedSearchQuerySet to look through the favorites table, but this executes a lot of SQL queries to filter a subset of…
user3897794
  • 31
  • 2
3
votes
1 answer

Questions on SQL Server 2008 Full-Text Search

I have some questions about SQL 2K8 integrated full-text search. Say I have the following tables: Car with columns: id (int - pk), makeid (fk), description (nvarchar), year (int), features (int - bitwise value - 32 features only) CarMake with…
Eddie
  • 197
  • 1
  • 2
  • 11
3
votes
0 answers

mysql fulltext query is very slow

I have one table for User detail in MySql with about 500000 records in it. I have also created fulltext index on firstname, lastname field on this table. but when I am trying to search any single latter/alphabet (e.g. a to z, single character), it…
Manish Sapkal
  • 5,591
  • 8
  • 45
  • 74
3
votes
0 answers

How can I create the virtual table using FTS in SQLite

How can I create the virtual table using FTS in SQLite. I have 3 tables, but I don't want to add the columns manually into the table. For example: I have the 3 tables like: t1(t1_id,t1_name), t2(t2_id,t2_name), t3(t3_id,t1_id,t2_id,t3_name) Now,…
Anjali Tunge
  • 139
  • 1
  • 5
3
votes
1 answer

Ignore acutes in LINQ when using "Contains"

Is it possible in pure LINQ-to-entities to use String's Contains() method without considering the acutes? Example: table Messages --------------------------- MessageId Body 1 Hello John how are you 2 Hi Jóhn sup? …
sports
  • 7,851
  • 14
  • 72
  • 129
1 2 3
…
99 100