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
3
votes
1 answer

Returning Rank with Full Text Search Contains Query

I have implemented Full Text Search on one of Sql Server 2008 Table. Query works fine when search some words using contains. I want to filter out the result on the basis of Rank functionality of Full Text Search. I am writing the following…
Deepesh
  • 4,626
  • 6
  • 27
  • 45
3
votes
3 answers

Using FTS query, Can you find all entries contains 'abc'

I am new to Full Text Search, how do I perform a search using Contains instead of using like in the following query Select * From Students Where FullName LIKE '%abc%' Thanks
Costa
  • 3,697
  • 11
  • 43
  • 75
3
votes
1 answer

Search special characters using to_tsquery

How to construct to_tsquery to search for special characters like , "_", etc... ? I have entry in my tsvector column like "v_130" and I would like to search for "v_130" but when I construct to_tsquery such as to_tsquery('v_130:*') it doesn't return…
is_this_the_way
  • 1,687
  • 22
  • 30
3
votes
1 answer

Best auto complete/suggest for a search form in rails 3

I have a rails app that uses the following, rails 3.1, ruby 1.9.2, mysql, sphinx search, will paginate, thinking sphinx, I opted not to use a gem for a simple login, so no devise, no authlogic. Login from scratch, using BCrypt for encrypting…
beck03076
  • 3,078
  • 1
  • 24
  • 36
3
votes
4 answers

How much more performant is Postgres than MYSQL on fulltext search?

I've been a MYSQL user,never tried Postgres . But MYSQL has bottle neck on fulltext search when the data set is huge.
omg
  • 123,990
  • 135
  • 275
  • 341
3
votes
2 answers

Sunspot with Solr 3.5. Manually updating indexes for real time search

Im working with Rails 3 and Sunspot solr 3.5. My application uses Solr to index user generated content and makes it searchable for other users. The goal is to allow users to search this data as soon as possible from the time the user uploaded it. I…
Sid
  • 5,762
  • 7
  • 31
  • 52
3
votes
1 answer

Optimize count and select query

I am using MySQL 5.5. I have a query (fulltext) which uses a subquery. To help performance and the fact that I am using pagination, I am using LIMIT to limit the number of results. SELECT * FROM ( SELECT id, type, type_id, content,…
F21
  • 28,366
  • 23
  • 91
  • 157
3
votes
1 answer

Query multivalued field in solr

I have a document like this: 2012-08-18T17:00:00Z 2012-06-28T17:00:00Z 2013-02-28T17:00:00Z 2012-04-16T17:00:00Z …
dtnam
  • 31
  • 1
  • 6
3
votes
2 answers

indexing and searching contents in project folder

Every time I try to find out a variable or string or some text in my codes (in project folder), I am in trouble. It seems I don't know easy techniques to do that. I was wondering if there is any tool which indexes a specified folder (in my case…
fireball003
  • 1,829
  • 4
  • 19
  • 24
3
votes
3 answers

How fast should my Mysql LIKE statement be?

The following MYSQL statement takes 0.577251 seconds: SELECT synonym_group FROM synonym WHERE name LIKE '%ak%' Name is a varchar(250) field. There are currently 356,187 records in the synonym database table. Data: 21 MB. Indexes: 23 MB. Total size:…
oyvey
  • 579
  • 1
  • 7
  • 20
3
votes
3 answers

How do fulltext indexers (or caches) work?

I wonder, how are systems for fulltext search implemented, to be able to query millions of entries very fast? Please note: I'm not talking about systems which tokenize the content by separating it at whitespaces, but about system which are able to…
ivan_ivanovich_ivanoff
  • 18,003
  • 24
  • 78
  • 100
3
votes
2 answers

Location Searching: Specific Address vs local businesses

I'm building a location app for iOS. I currently have a search bar that can be used to search for local business (e.g. pizza, gas station, bank). The search bar text is added as a parameter to a URL and fed to Yahoo Local API. I would like to use…
Gabriel Ortega
  • 481
  • 5
  • 16
3
votes
1 answer

Getting a TransientObjectException when creating my initial index

I'm using the following code to initialize my Hibernate Search index: EntityManager em = ... FullTextEntityManager fullTextEM = Search.getFullTextEntityManager(em); fullTextEM.createIndexer().startAndWait(); Now when I execute this code, I'm…
John S
  • 1,655
  • 2
  • 14
  • 23
2
votes
1 answer

How to integrate solr full text search engine in asp.net

How to integrate solr net in asp.net site. I am new and having little idea. After searching on google i am confused from where i should start. Please refer me some ref. link from where i can do this in better way. Thakns.
Anu
  • 733
  • 2
  • 13
  • 22
2
votes
1 answer

System.Data.Sqlite and FTS4

Why when i write a query with fulltext Search syntax like: SELECT * FROM TABLENAME WHERE TABLENAME MATCH 'ColumnA:word1 OR ColumnB:word2' The query result always return 0 rows? I'm using VBnet and the latest Ado.net provider from sqlite.org The…
popa big
  • 21
  • 2
1 2 3
…
99
100