Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
2
votes
1 answer

SQL Full Text search on HTML/XML data

I have a sql full text catalog on a cms database (SQL 2005). The database holds the CMS page content within a ntext column which is part of the full text catalog. As expected the searching takes into account the xml tags within the page content so…
Adam Jenkin
  • 4,142
  • 6
  • 25
  • 31
2
votes
1 answer

mongodb full text search and json objects

I am running mongodb v2.4.5. I have a document with the following fields: { "_id" : ObjectId(""), temp:"python", github_repo_languages" : { "python" : 17, "java" : 984 } } If I run the query: db.users.runCommand( "text", { search: "java"…
drfence
  • 1,487
  • 2
  • 17
  • 29
2
votes
1 answer

MySQL fulltext not returning any results when it clearly should be

I'm trying to create a fulltext search index across three columns but it's not returning any results even though it seems like it should. I've replicated the problem in a testtable with the following structure and data: CREATE TABLE IF NOT EXISTS…
John Mellor
  • 2,351
  • 8
  • 45
  • 79
2
votes
1 answer

Create Full Text index script on all columns without specifying each column by name

How can I have a full text index on all columns without specifying individual column names via script in SQL Server? My table has 50 columns, and I'd like the full text index to cover them all. Can this be done?
krishnakishore
  • 25
  • 1
  • 5
2
votes
1 answer

Strange SQL Server Fulltext match

I stumbled upon strange fulltextindex behavior in SQL Server 2008 R2 (my word-breaker language is German). I have this text indexed: [...] Java Editorerstellung in Eclipse eines Modellierungseditors(UML) mit den Eclipse Technologien [...] I…
Hannes Sachsenhofer
  • 1,835
  • 1
  • 23
  • 38
2
votes
1 answer

PostgreSQL : Gin max fields size

I'm currently evaluating many FullText indexing solutions, and I'm playing with native postgres FT. I'm trying to index my data using GIN indices. But there's a limitation in the field size, I encounter some errors saying "huge tuple" while…
user155118
2
votes
2 answers

Text Search Engine for Mailing List Archive Cataloging and Search

I'm working with a mailing list archive and am tasked with setting up basic search, boolean search, and ultimately some sort of more intelligent tag-based searching. I see both commercial products and some open-source projects (like Lucene.NET) Has…
Caveatrob
  • 12,667
  • 32
  • 107
  • 187
2
votes
2 answers

Perforce Full-text Searching

Quick question as likely I will have more later. I'm currently investigating document management solutions and was wondering if anyone has been able to set up full-text searching of a Perforce depot? Specifically for Microsoft Office documents…
Dennis
  • 20,275
  • 4
  • 64
  • 80
2
votes
0 answers

Document storage / searching

I am hoping you can point me in the direction of the correct technologies. I am part of a small software development team that have good skills in c# development and SQL databases. We have been tasked with writing a document storage application.…
John
  • 189
  • 1
  • 10
2
votes
1 answer

Using Match and Against in MySQL and CodeIgniter

I am trying to implement a search feature into my codeIgniter project. I have a table called product_search, where I am set a fulltext index using the following command: ALTER TABLE `product_search` ADD FULLTEXT (`prod_title`, `prod_desc`) I then…
Phil Young
  • 1,334
  • 3
  • 21
  • 43
2
votes
1 answer

Re-build SQL Server Full Text Index

I have a client who is utilizing full-text indexing in their application. They rebuild the indexes via the application. When they do this, the manually remove all columns from the catalog. Then they add them all back. After doing that they start a…
Dan
  • 195
  • 1
  • 3
  • 10
1
vote
0 answers

Why MySQL return 0 result of in my query MATCH?

I am developing an application using Codeigniter 2.1.0 and MySQL. In my application I have a search feature. Here is code for search. function get_results($query, $post_per_page,$current_page) { $offset=($current_page-1)*$post_per_page; …
Seek Php
  • 163
  • 2
  • 3
  • 12
1
vote
1 answer

Sql Server 2008 Full-Text Index (characters issue)

The Full-Text Index searching is working perfect but suddenly I noticed that it fails when it comes to some characters variance in Arabic In Arabic we have a trailing letter say {I} that can be written like { i } or { I } , It's the same letter but…
Mosh Ana
  • 11
  • 1
1
vote
1 answer

MySQL full text searching data included in foreign keys

First of all my data is stored using the MyISAM engine as I'm aware InnoDB does not support full text search indexing at this time on linux. I do however use foreign keys, although obviously this is not referentially enforced. I have 3 tables…
leejmurphy
  • 994
  • 3
  • 17
  • 28
1
vote
1 answer

IndexTank - How to prioritize result of a query

Using the indextank rubygem, if I index a post like this indexes.document(post.id).add({:title=> post.title, :text=> post.body}) What should my query look like such that the title matches are returned before the body matches. Doing this:…
Akshay Rawat
  • 4,714
  • 5
  • 40
  • 65
1 2 3
…
37 38