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.

7350 questions
47
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,407
  • 4
  • 28
  • 35
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,310
  • 2
  • 23
  • 23
45
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
  • 36,348
  • 48
  • 182
  • 274
43
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,646
  • 3
  • 18
  • 24
43
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
  • 15,930
  • 6
  • 39
  • 63
43
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
  • 685
  • 3
  • 7
  • 8
43
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
  • 449
  • 1
  • 4
  • 4
42
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,203
  • 8
  • 12
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
  • 5,739
  • 30
  • 99
  • 162
40
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,759
  • 4
  • 21
  • 33
40
votes
3 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,386
  • 1
  • 14
  • 32
40
votes
5 answers

SQL Server 2008 Full Text Search (FTS) versus Lucene.NET

I know there have been questions in the past about SQL 2005 versus Lucene.NET but since 2008 came out and they made a lot of changes to it and was wondering if anyone can give me pros/cons (or link to an article).
ajma
  • 11,695
  • 11
  • 67
  • 87
40
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
  • 9,088
  • 20
  • 70
  • 136
39
votes
1 answer

Using Full-Text-Search in order to find partial words (SQL Server 2008)

I'm trying to build a facebook like search for my software. I'd like to query the table customers. I've set up a FULLTEXT Index and tried the next query SELECT * FROM Customer where CONTAINS(*,'*ann*') The query does return all the customers named…
Dig
  • 3,470
  • 2
  • 23
  • 33
39
votes
2 answers

Optimal data architecture for tagging, clouds, and searching (like StackOverflow)?

I'd love to know how Stack Overflow's tagging and search is architected, because it seems to work pretty well. What is a good database/search model if I want to do all of the following: Storing Tags on various entities, (how normalized? i.e.…
Winston Fassett
  • 3,314
  • 3
  • 32
  • 28
1 2
3
…
99 100