I have a feeling this question might have been asked before, but I am not able to find it. So here it goes: I am searching through articles for words, phrases typed by users on a website my articles have different columns for title, keywords, body, summary. when I am searching I want the result to be more relevant if found in Title tha...
Is it possible to restrict the rows that are included in a FT catalog for a given table? For example, I would want only rows with IsActive=TRUE to contribute to the catalog and be searchable. Possibly this may reveal a lack of understanding on my part of FTS. I'm wondering whether there would be advantages in performance if the catalog ...
Hi, I'm using MATCH() AGAINST() with a fulltext index and I was wondering how I could setup a "keywords" data field. So let's say I have a a fulltext index on the "title" column, which for example might have a row with the value of "AC/DC".. I want to have a field to enter additional keywords like "ACDC" "AC DC" and "AC-DC" Ideally I'd...
Hi, I have a rails app which I want to make searchable with tenderlove's texticle. In the console it works fine, but in my app I get an error like this: /opt/local/lib/ruby/gems/1.8/gems/texticle-1.0.3/lib/texticle.rb:65:in `index' /Users/vjmayr/.gem/ruby/1.8/gems/activerecord-2.3.8/lib/active_record/named_scope.rb:92:in `call' /Users/v...
Hi I have a table in SQL Server with the following columns: id int (primary key) text nvarchar(max) (full text indexed) type int and I have queries like this: where Contains([text], @text) or where Contains([text], @text) AND [type] = 3 However the second query is slow. I think I should integrate full text index with [type] fie...
I'm getting results that are hard to understand. I hope that someone will be able to shade some light on the subject. I have a very simple table in mysql: id| text 1 | testA testB testC 2 | testA testB When I run the following query: SELECT id, MATCH (text) AGAINST ('+(+testA testB) +testC' IN BOOLEAN MODE) as score FROM test_full...
Hello Folks, I have been reading the Full Text help files for CONTAINS, FREETEXT, CONTAINSTABLE and so forth on MSDN and elsewhere, but I am not able to find the solution I am looking for. I would like to be able to query with the following criteria: Example value: "The quick brown fox jumped over the lazy dogs." Select * from MyText...
I'm trying to implement a simple search engine over a list of HTML documents. I've build a script that generates the needed list of links. There is no need for crawling any other documents. So far I've tried Solr / Nutch (I'm still trying to get them working...), but they feel way overkill for such a simple task. I'm looking for somethi...
Greetings Overflowers, I'm currently not using full-text indexing/searching capabilities of any relational database engine. This is because they do not satisfy my application complex query requirements: searching by Arabic root/template/stem/diacritics... etc ("/" stands for and/or) using logical operators between them (in 1) such as ...
What is the best way trying to get a text search function using nhibernate? I have read about NHibernate.Search, but cannot find the library anywhere. I downloaded the latest NHibernate source code(2.1.2) and compiled it, but i still cannot find NHibernate.Search. Does anyone have any suggestions? Or any other methods to do text search...
I get the following error when trying to add a FULLTEXT index to Title, Edition and Author in my MySQL database: Specified key was too long; max key length is 1000 bytes Here are the columns: `Title` varchar(255) NOT NULL, `Edition` varchar(20) default NULL, `Authors` varchar(255) default NULL, None of them are unique.. Even th...
First of all: I have fruitlessly tried searching Stackoverflow.com for any clues on my problem, however if I have missed anything, please let me know! In my database I have a table containing metadata (i.e. description etcetera) and some other information (file names, etc) about a number of files. I'd like to provide the users with...
I have basic stored procedure that performs a full text search against 3 columns in a table by passing in a @Keyword parameter. It works fine with one word but falls over when I try pass in more than one word. I'm not sure why. The error says: Syntax error near 'search item' in the full-text search condition 'this is a search item' SEL...
Hi everyone, I've been playing around with apache's cassandra project. Done a fair bit of readin and i have some fairly complex examples that i've done, including inserting single and batch sets of data, retrieving a single and multiple data sets based on keys. Some of the articles i've looked at include http://www.rackspacecloud.com/...
I'm going to build a search engine on solr, and nutch as a crawler. I have to index about 13mln documents. I have 3 servers for this job: 4 core Xeon 3Ghz, 20Gb ram, 1.5Tb sata 2*4 core Xeon 3Ghz, 16Gb ram, 500Gb ide 2*4 core Xeon 3Ghz, 16Gb ram, 500Gb ide One of the servers I can use as a master for crawling and indexing, other twos...
I have a query that is running something like this in SQL Server 2008 Select [key], Rank From ContainsTable(tblDocuments, '"Exact Match"') At the time we decided to use SQL FTS Exact Matching wasn't a requirement; sadly requirements move on and now we are interested in the possibility of getting exact matches too - i am not in a place...
Hi, I'm using Zend_Search_Lucene for full-text search of records in several different tables in my application. I have just implemented this functionality, and currently the index is built upon first use of the search functionality after application deployment. This is obviously not what I would like in production. I'm looking for an e...
how can i use FREETEXT in sqlserver 2008? i have search problem? Its like a monster jobs search in key words please send me reply thank you ...
how can i search for a particular string in mysql? I tried using contains- gives me error: SELECT r.name , r.network , r.namestring , i.name , r.rid , i.id , d.dtime , d.ifInOctets , d.description FROM router AS r INNER JOIN interface AS i ON r.rid = i.rid INNER JOIN 1278993600_1_60 AS d ON i.id =...
I'm using FULLTEXT natural language search, and I notice that it automatically sorts my results by relevance. However, when I start to add things to ORDER, it seems to no longer sort by relevance. Is there a way to explicitly set the importance of relevance sorting? ...