How can I build a search engine for a knowledge base system?
I need to build full-text search functionality into our knowledge base system using C#. How do I start? ...
full-text-search
How to index and find numbers with Lucene.NET?
I've implemented full text search for a web site using Lucene.NET (Version 2.0). Indexing and searching works well, but I have one problem. If I look for numbers (phone numbers, product numbers etc.) as search terms, I don't get any resulting documents. I'm using the Lucene.Net.Analysis.SimpleAnalyzer Class. I guess I have to change Ana...
SQL Server - Fulltext search for %book%
Folks, I'm trying to wrap my head around how to search for something that appears in the middle of a word / expression - something like searching for "LIKE %book% " - but in SQL Server (2005) fulltext. How can I do that?? It almost appears as if both CONTAINS and FREETEXT really don't support wildcard at the beginning of a search expre...
Partial Keyword Searching (MS SQL 2005)
Current, I've got a stored procedure that has a main goal of doing a full text search through a database table of films and tv shows. In order to get it to do partial-keyword searching, I added some code in SQL to split up the search query by spaces, and output a statement like the following: ' "batman*" ~ "be*" ' The original string,...
Comparison: DB Full Text search to Search engine (Lucene)
With stackoveflow.com in perspective (team of 2-3 engineers building a website project intended to scale) does it make sense to spend effort early in the process of development to build a search based on Lucene/Autonomy… as opposed to a database based full text search. Pros/Cons: With a mature Lucene implementation like nutch or auton...
How do I insert Chinese characters into a SQLExpress text field?
How do I insert Chinese characters into a SQLExpress text field? I'm using SQL Express from VS 2008. When I add Chinese characters, either via an import app I wrote or by pasting them in from the data view inside Visual Studio, they end up as question marks. ...
SQL Server Weighted Full Text Search
Currently I have a table that I search upon 4 fields, FirstName, LastName, MiddleName, And AKA's. I currently have a CONTAINSTABLE search for the rows and it works. Not well but it works. Now I want to make the First Name weighted higher and middle name lower. I found the command ISABOUT but that seems pretty worthless if I have to do i...
Is it possible to use CONTAINSTABLE to search for "word1" in column1 AND "word2" in column2
We used to have a search, that checks two columns for some words. Both columns must contain some words provided, so we use AND ... no doubts FULLTEXT INDEX is used on the columns. The select is more or less like this: SELECT * FROM SomeTable WHERE (CONTAINS(Column1, 'word1 OR word2') AND CONTAINS(Column2, 'word3 OR word4')) now ...
Tools to search for strings inside files without indexing
I have to change some connection strings in an incredibly old legacy application, and the programmers who made it thought it would be a great idea to plaster the entire app with connection strings all over the place. VS "current project" search is INCREDIBLY slow, and I don't trust Windows Search. So what's the best free, non-indexed t...
Ranking of Full Text Search (SQL Server)
For the last couple hours I have been messing with all sorts of different variations of SQL Server full text search. However I am still unable to figure out how the ranking works. I have come across a couple examples that really confuse me as to how they rank higher then others. For example I have a table with 5 cols + more that are not...
Which is the best opensource project which uses lucene extensively?
Either in .net or java. ...
Does anyone know if there is a list of German words used in the Fulltext word breaker?
SQL Server Full Text Search uses language specific Word Breakers. For the German language this is used to break/split words including compound words. However, it appears not all known compound words are included in the Word Breaker. I would like to know if a list is available of the words the Word Breaker does know about. ...
Search using Windows for files ending in jsp
I'm trying to search using the windows search one of my web directories for any uses of scriptlets. However, the search seems to be ignoring all files ending in .jsp. I searched for plain words, and that didn't work either. Is there a reason Windows ignores these files when searching? ...
mysql fulltext search "all but" query
I need to query the table for "all but keyword". Using just "-" doesn't work, and in fact mysql manual says: Note: The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. It does not return “all row...
Full text search on a table
How to enable and perform a "full text" search on a table in SQL Server 2005? I did not quite understand the solution in: http://stackoverflow.com/questions/206142/how-do-i-use-full-text-search-accross-multiple-tables-mssql-2005 ...
MSSQL -- Create View with PK
My create view code like this create VIEW [dbo].[vw_test] AS SELECT 'B' AS rtype, ID FROM TB_A UNION ALL SELECT 'V' AS rtype, ID FROM TB_B GO How to create a PK with. I need to do full-text search. Tks ...
Escape double quotes in SQL 2005/2008
I have an international company that has recently been added, which is named "BLA "BLAHBLAH" Ltd. (The double quotes are part of the name. ) Whenever a user tries to search for this company, by entering "Blah, or something to that affect, the search fails with a syntax error in SQL server. How can I escape this so the search will not f...
Does Microsoft Access have Full Text Search?
Does Microsoft Access have Full Text Search? I know that MySQL and SQL Server have Full Text Search, but I am not too certain on Access. If Access doesn't have Full Text, what is the best alternative to achieve the same objective of Full Text Search? Thanks ...
Using Full-Text Search in SQL Server 2008 across multiple tables, columns
I need to search across multiple columns from two tables in my database using Full-Text Search. The two tables in question have the relevant columns full-text indexed. The reason I'm opting for Full-text search: 1. To be able to search accented words easily (cafè) 2. To be able to rank according to word proximity, etc. 3. "Did you mean...
Need help in getting PostgreSQL substring search with full text search working in my Django project
I am using the Python, Django framework and PostgreSQL combination. I am using the full text search of PostgreSQL (8.3) and am overriding the default filter function of Manager class in Django. Using the link: http://barryp.org/blog/entries/postgresql-full-text-search-django/ I was able to configure my full text search, as mentioned in t...