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
53
votes
4 answers

Limit the number of results returned by Elastic Search

I am having an issue where i want to reduce the number of results from Elastic search to 1,000 no matter how many matching results are there matching, but this should not affect the ranking and scoring. I was trying terminate_after, but that seems…
RohitWagh
  • 1,999
  • 3
  • 22
  • 43
51
votes
13 answers

How do you get leading wildcard full-text searches to work in SQL Server?

Note: I am using SQL's Full-text search capabilities, CONTAINS clauses and all - the * is the wildcard in full-text, % is for LIKE clauses only. I've read in several places now that "leading wildcard" searches (e.g. using "*overflow" to match…
Greg Hurlman
  • 17,666
  • 6
  • 54
  • 86
51
votes
2 answers

Can I configure PostgreSQL programmatically to not eliminate stop words in full-text search?

I'm using PostgreSQL full text search for a project where traditional stop words ('a', 'the', 'if' etc.) should be indexed and searchable, which is not the default behaviour. For example, I might want my users to find results for the query 'to be or…
tomd
  • 1,373
  • 1
  • 8
  • 12
49
votes
6 answers

How to search multiple columns in MySQL?

I'm trying to make a search feature that will search multiple columns to find a keyword based match. This query: SELECT title FROM pages LIKE %$query%; works only for searching one column, I noticed separating column names with commas results in an…
George
  • 509
  • 1
  • 4
  • 4
49
votes
4 answers

MongoDB Text Search AND multiple search words

I have an index on an array "keys" that I am using to provide full text functionality to my applicaiton. With the release of 2.4.3, I'd like to utilize the "text" index type. I insured a "text" index type on my array "keys" and it seems to work…
kmehta
  • 2,457
  • 6
  • 31
  • 37
48
votes
8 answers

Is there a pure Python Lucene?

The ruby folks have Ferret. Someone know of any similar initiative for Python? We're using PyLucene at current, but I'd like to investigate moving to pure Python searching.
PEZ
  • 16,821
  • 7
  • 45
  • 66
48
votes
1 answer

PostgreSQL Full Text Search and Trigram Confusion

I'm a little bit confused with the whole concept of PostgreSQL, full text search and Trigram. In my full text search queries, I'm using tsvectors, like so: SELECT * FROM articles WHERE search_vector @@ plainto_tsquery('english', 'cat, bat,…
Devin Dixon
  • 11,553
  • 24
  • 86
  • 167
48
votes
3 answers

Best practices for searchable archive of thousands of documents (pdf and/or xml)

Revisiting a stalled project and looking for advice in modernizing thousands of "old" documents and making them available via web. Documents exist in various formats, some obsolete: (.doc, PageMaker, hardcopy (OCR), PDF, etc.). Funds are available…
Meltemi
  • 37,979
  • 50
  • 195
  • 293
47
votes
4 answers

Searching for Text within Oracle Stored Procedures

I need to search through all of the stored procedures in an Oracle database using TOAD. I am looking for anywhere that the developers used MAX + 1 instead of the NEXTVAL on the sequence to get the next ID number. I've been doing SQL Server for years…
PseudoToad
  • 1,504
  • 1
  • 16
  • 34
47
votes
3 answers

Performance of like '%Query%' vs full text search CONTAINS query

I have a situation where I would like to search a single word. For that scenario, which query would be good from a performance point of view? Select Col1, Col2 from Table Where Col1 Like '%Search%' or Select Col1, Col2 from Table Where Col1…
dotnetguts
  • 735
  • 3
  • 7
  • 8
46
votes
6 answers

PostgreSQL: Full Text Search - How to search partial words?

Following a question posted here about how I can increase the speed on one of my SQL Search methods, I was advised to update my table to make use of Full Text Search. This is what I have now done, using Gist indexes to make searching faster. On some…
Anthoni Gardner
  • 929
  • 1
  • 9
  • 17
45
votes
9 answers

How can I manipulate MySQL fulltext search relevance to make one field more 'valuable' than another?

Suppose I have two columns, keywords and content. I have a fulltext index across both. I want a row with foo in the keywords to have more relevance than a row with foo in the content. What do I need to do to cause MySQL to weight the matches in…
Buzz
  • 1,616
  • 3
  • 18
  • 25
45
votes
6 answers

How to evaluate hosted full text search solutions?

What are the options when it comes to SaaS/hosted full text search? How should I evaluate the different options available? I'm looking for something that uses Lucene, solr, or sphinx on the backend, and provides a REST API for submitting documents…
James Cooper
  • 2,320
  • 2
  • 23
  • 23
42
votes
4 answers

PHP mysql search multiple tables using a keyword

I have three tables in my database which are: messages topics comments Each of these tables has two fields called 'content' and 'title'. I want to be able to use 'Like' in my sql statement to look at 'messages.content', 'messages.title',…
Eyad Fallatah
  • 1,859
  • 4
  • 22
  • 34
41
votes
2 answers

SQL Server 2012 Install or add Full-text search

I am working in SQL Server 2012, and would like to use the CONTAINS() function only it seems I need to have full-text search enabled for to be able to use it. How do I enable/install this feature to an existing SQL Server 2012 install? What I need…
Kobojunkie
  • 6,375
  • 31
  • 109
  • 164
1 2
3
…
99 100