I am doing a MS SQL Server Full Text Search query. I need to escape special characters so I can search on a specific term that contains special characters. Is there a built-in function to escape a full text search string ? If not, how would you do it ? ...
I am using Lucene.Net for indexing and searching documents, and I am using the following code to create or open an index if one exists: IndexWriter writer = new IndexWriter(@"C:\index", new StandardAnalyzer(), !IndexExists); private bool IndexExists { get { return ?? } } now how can ...
I have a SQL Server 2008 database with a large amount of varchar(max) data that is currently indexed with full-text search. Unfortunately, row-level compression in SQL Server 2008 does not support LOB data. I am toying with the idea of using SQLCLR to compress the data and a custom iFilter to enable the data to be indexed with full-text...
Hello! 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 query even parts from the middle of tokens (which is a real challange). Background...
I have a search box that can contain multiple values using a comma, eg Pasta, tuna, eggs Im using FULLTEXT mysql search but I need to use some kind of preg_replace to turn Pasta, tuna, eggs into 'Pasta','tuna','eggs' If I enter this 'Pasta','tuna','eggs' into the search box the results are correct. Thanks people ...
Hi, 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 project folder) and updates in real-time (with updating codes). Also any string can be se...
Ok, Today I am trying to learn Subsonic. Pretty cool stuff. I am trying to build some search functionality into my website but am struggling about how I might achieve this in Subsonic. I have one search field that could contain multiple keywords. I want to return results that match all of the keywords. The target on the search is a...
I have MySQL on shared hosting. Is there any way how to change value of ft_min_word_len without administrator access? I found one workaround, where every word, that has less than 4 characters is supplemented with _ or some other char, and the same is done with every searched keyword that is less than 4 characters. Is there any bett...
Hey , i got this challenge , i got a MySQL DB table 1 with queries or text and table 2 with synonyms and misspellings as CSV [comma separated values]. Now i want to test if any query word in table 1 matches a synonym or misspelling in table 2 , then i would select them separately . example : table 1 row: "i am sick of HIV AIDS , what...
I need to do full text searching with Google App Engine. I found the project Whoosh and it works really well, as long as I use the App Engine Development Environement... When I upload my application to App Engine, I am getting the following TraceBack. For my tests, I am using the example application provided in this project. Any idea of ...
I have a small site with about 500 photos and 150 visitors per day which is hosted on Dreamhost. I would like to add a simple search engine that does not need to run long time processes which are not allowed on shared host. The search engine should process different fields belonging to various models: Photo, Photo.author.name, Photo.com...
I'm refactoring an old database and removing columns no longer in use. The DB used to have full text indexing, so, some column are marked for full text. How can I remove them? Notes: DB is MS SQL Server Express 2008 Full text search service is no longer installed Edit: I have tried ALTER FULLTEXT INDEX ON tableName DROP (Colu...
I''ve a little problem while using SQL Server Full Text Search. Let me explain, I've a table with a BLOB inside (a PDF file). I've created the full text index in that table like it should be. I've the PDF iFilter from Adobe. BUT, when I put some files in my table and execute a search like: SELECT * FROM MyTable WHERE FREETEXT(*, N'...
Hi, I'm using Ultrasphinx for a fulltext search in a rails app. I encountered a very strange behavior. When I search my User model and search for q = "user" I get all the users as a result, even though some of them havent got the term "user" in any field. What is going wrong here? Heres my setup: # models/user.rb class User < ActiveR...
I am trying to implement a basic full-text search with MySQL. I wrote this migration: def self.up execute 'ALTER TABLE photos ENGINE = MyISAM' execute 'CREATE FULLTEXT INDEX fulltext_photos ON photos (place, info)' end def self.down execute 'ALTER TABLE photos ENGINE = InnoDB' execute 'DROP INDEX fulltext_photos ON photos' en...
We have a framework that has hundreds of XML files/text files/resources that decide the behavior of the system.(the huge number is because of legacy reasons) Other teams use this framework and build different products on top of it. To build a product using the framework, typically means configuring the XML files in various different wa...
Hi, I have a website that utilizes MS SQL 2008's FTS (Full-Text Search). The search works fine if the user searches for a string with an apostrophe like that's - it returns any results that contain that's. However, it will not return a result if the user searches for thats, and the database stores that's. Also, ideally a search for tha...
Can anybody recommend a good book(s)/paper(s)/article(s) on Full Text Search (and maybe indexing in general). I'm pretty anal about having to understand what's happening behind the scenes in my applications, and I'm having trouble understanding why Sphinx and other external FTS's leaves MySQL/MyISAM in the dust. ...
Is it possible to allow users to search inside the available files loaded on Jboss Portal CMS ? ...
Hi all. Suppose I have Sql Server (2005/2008) create an index from one of my tables. I wish to use my own custom search engine (a little more tuned to my needs than Full Text Search). In order to use it however, I need Sql Server to provide me the word positions and other data required by the search engine. Is there anyway to query t...