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
84
votes
6 answers

Search for "whole word match" in MySQL

I would like to write an SQL query that searches for a keyword in a text field, but only if it is a "whole word match" (e.g. when I search for "rid", it should not match "arid", but it should match "a rid". I am using MySQL. Fortunately, performance…
Oddthinking
  • 24,359
  • 19
  • 83
  • 121
84
votes
5 answers

MySQL match() against() - order by relevance and column?

Okay, so I'm trying to make a full text search in multiple columns, something simple like this: SELECT * FROM pages WHERE MATCH(head, body) AGAINST('some words' IN BOOLEAN MODE) Now i want to order by relevance, (how many of the words are found?)…
Kristoffer la Cour
  • 2,591
  • 3
  • 25
  • 36
77
votes
6 answers

Is it possible to use Full Text Search (FTS) with LINQ?

I wonder if is possible to use FTS with LINQ using .NET Framework 3.5. I'm searching around the documentation that I didn't find anything useful yet. Does anyone have any experience on this?
Edwin Jarvis
  • 5,980
  • 6
  • 36
  • 41
76
votes
3 answers

What is the use of "multiValued" field type in Solr?

I'm new to Apache Solr. Even after reading the documentation part, I'm finding it difficult to clearly understand the functionality and use of the multiValued field type property. What internally Solr does/treats/handles a field that is marked as …
Gnanam
  • 10,613
  • 19
  • 54
  • 72
74
votes
5 answers

IntelliJ IDEA global search

I would like to search across projects for variable usages, or at least for strings. I've got IndexYourFiles which works well for text searches, but I have to re-index every now and then and would like an integrated solution. Is there any way…
Jon Onstott
  • 13,499
  • 16
  • 80
  • 133
74
votes
5 answers

What is the meaning of O( polylog(n) )? In particular, how is polylog(n) defined?

Brief: When academic (computer science) papers say "O(polylog(n))", what do they mean? I'm not confused by the "Big-Oh" notation, which I'm very familiar with, but rather by the function polylog(n). They're not talking about the complex analysis…
Managu
  • 8,849
  • 2
  • 30
  • 36
72
votes
3 answers

PostgreSQL(Full Text Search) vs ElasticSearch

Hi I am doing some research before I implement search feature into my service. I'm currently using PostgreSQL as my main storage. I could definitely use PostgreSQL's built-in Full-Text-Search but the problem is that I have data scattered around…
J.S.C
  • 1,323
  • 3
  • 16
  • 22
71
votes
4 answers

How reliable is ElasticSearch as a primary datastore against factors like write loss, data availability

I am working on a project with a requirement of coming up with a generic dashboard where a users can do different kinds of grouping, filtering and drill down on different fields. For this we are looking for a search store that allows slice and dice…
Harshit Agrawal
  • 903
  • 1
  • 7
  • 11
71
votes
6 answers

Any reason not use PostgreSQL's built-in full text search on Heroku?

I'm preparing to deploy a Rails app on Heroku that requires full text search. Up to now I've been running it on a VPS using MySQL with Sphinx. However, if I want to use Sphinx or Solr on Heroku, I'd need to pay for an add-on. I notice that…
Ethan
  • 57,819
  • 63
  • 187
  • 237
67
votes
1 answer

Google Sites API full-text search does not work for non-Western languages

In my JavaEE application, I'm using the Atom-based Google Sites API to retrieve content from a non-public Google Site. In essence, we're using the Google Site as a lightweight CMS, and from within the application I use the API to retrieve the site…
Robby Cornelissen
  • 91,784
  • 22
  • 134
  • 156
65
votes
4 answers

Full text search with weight in mongoose

As I find out, since version 3.8.9, mongoose support full text search. But I can't find a good documentation for it! I want to do something like: db.collection.ensureIndex( // Fields to index { animal: "text", color: …
Foad Nosrati Habibi
  • 1,134
  • 1
  • 8
  • 13
58
votes
5 answers

Can't find FULLTEXT index matching the column list (indexes is set)

I'm working with fulltext, I executed an command to add the fulltext index to multiple comments, and returned no errors, then I did: SELECT * FROM products WHERE MATCH(`brand`) AGAINST('Skoda'); Which is in the brand column - but I get…
LucasRolff
  • 1,228
  • 3
  • 11
  • 20
56
votes
11 answers

Text search though all .xib files in Xcode?

This seems like such a basic task, but I'm stumped. How, in Xcode, do you execute a textual search though (the XML contents of) all the .xib files in a project? For example, all of our .xib files contain this string on the second line:…
Jon-Eric
  • 16,977
  • 9
  • 65
  • 97
55
votes
5 answers

Entity Framework, Code First and Full Text Search

I realize that a lot of questions have been asked relating to full text search and Entity Framework, but I hope this question is a bit different. I am using Entity Framework, Code First and need to do a full text search. When I need to perform the…
Eric
  • 1,945
  • 3
  • 23
  • 33
53
votes
4 answers

When should you use full-text indexing?

We have a whole bunch of queries that "search" for clients, customers, etc. You can search by first name, email, etc. We're using LIKE statements in the following manner: SELECT * FROM customer WHERE fname LIKE '%someName%' Does full-text…
Esteban Araya
  • 29,284
  • 24
  • 107
  • 141
1
2
3
…
99 100