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
3 answers

Oracle Text: How to sanitize user input

If anyone has experience using Oracle text (CTXSYS.CONTEXT), I'm wondering how to handle user input when the user wants to search for names that may contain an apostrophe. Escaping the ' seems to work in some cases, but not for 's at the end of the…
chris
  • 36,094
  • 53
  • 157
  • 237
3
votes
1 answer

Client side search engine optimization

Due to the reasons outlined in this question I am building my own client side search engine rather than using the ydn-full-text library which is based on fullproof. What it boils down to is that fullproof spawns "too freaking many records" in the…
David Mulder
  • 26,123
  • 9
  • 51
  • 114
3
votes
1 answer

How to structure Elasticsearch indices/types?

How would you structure indices/types for an eshop application? Such an eshop would consist of domain objects like product, category, tag, manufacturer etc. The fulltext search results page should display intermixed list of all domain objects. I…
Jakub Kulhan
  • 1,572
  • 2
  • 16
  • 37
3
votes
0 answers

Django-haystack full text search working but facets don't

Using django-haystack and elasticsearch. Full text search is working ok, but I have trouble to implement facets. I've searched tutorial on web but with no success, in other words didn't understand any of them. I am beginner in programing, so some…
edo
  • 66
  • 7
3
votes
0 answers

Is it possible to set a TTL on a document (i.e. automatically expire) added to the search index?

I would like to index data where each document expires x days after its creation date. Is it possible to have a sort of TTL on each document added to the index?
johnflan
  • 321
  • 4
  • 15
3
votes
1 answer

How can I implement a sounds like/soundex search using Google Appengine Full Text Search?

Is there some way to make a "sounds like" query against an appengine search index? For example, I have the document: my_document = search.Document( doc_id = 'PA6-5000', fields=[search.TextField(name='customer', value='John Jackson')]) index…
Greg
  • 33,450
  • 15
  • 93
  • 100
3
votes
1 answer

Android sqlite fts3 match and compare integer/float

We have a sqlite fts3 table without enhanced syntax(Android!!!) where we use a query like this: SELECT * FROM tableName WHERE tableName MATCH 'name*' AND validTo > 1389999600000 LIMIT 10 This works fine on iOS with fts4 and enhanced syntax, the…
Morten Holmgaard
  • 7,484
  • 8
  • 63
  • 85
3
votes
1 answer

Why is this SQL script failing?

I'm trying to run a SQL script against SQL Server 2005 as part of the set up for my integration tests. The script works perfectly fine if I execute it from within SQL Server Management Studio. However, when executing programmatically, this part of…
Kent Boogaart
  • 175,602
  • 35
  • 392
  • 393
3
votes
1 answer

Why is search performance is slow for about 1M documents - how to scale the application?

I have created a search project that based on lucene 4.5.1 There are about 1 million documents and each of them is about few kb, and I index them with fields: docname(stored), lastmodified,content. The overall size of index folder is about 1.7GB I…
ikel
  • 1,790
  • 6
  • 31
  • 61
3
votes
2 answers

Is it possible to combine NEAR and FORMSOF together in a fulltext search?

I have this: SELECT * FROM AwesomePeople WHERE CONTAINS(Name, 'NEAR(("Nathan", "Fillion"), MAX, TRUE)') But I want to combine it so it uses my thesaurus of words to look at alternatives for Nathan and Fillion. I can do this: SELECT * FROM…
NibblyPig
  • 51,118
  • 72
  • 200
  • 356
3
votes
1 answer

PostgreSQL. Full-text search performance

all! I have a table created in PostgreSQL 9.3 that contains about 24 millions records with the following structure: CREATE TABLE jtest ( recordid uuid NOT NULL, details json, tsv tsvector, CONSTRAINT jtest_pkey PRIMARY KEY (recordid) ) WITH…
user3111365
  • 31
  • 1
  • 2
3
votes
1 answer

MySQL FULLTEXT search for words at beginning or end of string

Posting this one so I can perhaps save some other poor sap from a few hours of searching, or better yet, get a better answer from someone smarter than I in the realm of MySQL. ;-) How, when searching MySQL using a FULLTEXT index, can I specify that…
Rick Riensche
  • 1,050
  • 1
  • 12
  • 25
3
votes
2 answers

How do I check if stopwords are enabled on a full-text indexed table?

I know how to enable them on my full text indexed table, but I don't know how to check if they are already enabled using an SQL command. Can anyone shed some light on this?
NibblyPig
  • 51,118
  • 72
  • 200
  • 356
3
votes
2 answers

How can I search on list of values using Lucene Query interface

Simplistic Problem description: Lucene index has two fields per document: ID and NAME. I want to make a query using the Lucene Query interface such that I can find all the documents where ID is 1 OR 2 OR 3 OR so on. The IDs to be searched will be in…
Jeewan
  • 37
  • 1
  • 1
  • 4
3
votes
3 answers

SQLite Virtual Table Match Escape character

I'm working on an applications where the indices are stored in a SQLite FTS3 virtual table. We are implementing full text matches which means we send through queries like: select * from blah where term match '' That's all well and…
Wysawyg
  • 712
  • 8
  • 22
1 2 3
…
99
100