I've a client testing the full text (example below) search on a new Oracle UCM site. The random text string they chose to test was 'test only'. Which failed; from my testing it seems 'only' is a reserved word, as it is never returned from a full text search (it is returned from metadata searches). I've spent the morning searching oracl...
I'm using the windows search 4.0 service (wssql) to find some files, it works fine on my computer but on our server which has two drives C: and D: always returns 0 rows when searching D: Also i'm not sure if it's related but cd d: goes back to c: in the command prompt. Edit: Ok it appears that it only returns zero rows when I specify ...
I have a Product table with the fields Id, Title, Description, Keywords (just comma separated list of keywords). Table is full-text indexed. When I view one product, I do a query and search the full-text catalog for any related products based on the Keywords field. select * from Products where Contains(Products.*, @keywordsFromOnePr...
Like above - I've got a ThinkingSphinx search implemented in my rails app. Searching works perfectly but - only for records with ids < 6145. Last correct search can be performed for id = 6144 I'm searching trough several models (Article, Newsitem, Video, Post) If anyone knows what could cause such a problem - please let me know. Thanks...
I'm using SQL Server 2008 FTS and I'd like to be able to integrate weighted rankings into my search results. However, I'd like to weight the columns that a search term is found in differently. For example, if I have a Title column and a Description column, I want matches fond in Title to rank higher than matches in Description. Is th...
I have an Incident table with one row that has the value 'out of office' in the Description column. However the following query does not return that row. SELECT * FROM Incident WHERE CONTAINS( (Incident.Description), '"out*"' ) The word 'out' is not in the noise file (I cleared the noise file completely and I rebuilt the index). Is ...
Related to my previous question (found here), I want to be able to implement the answers given with a 2 dimensional array, instead of one dimensional. Reference Array row[1][0]: 13, row[1][1]: Sony row[0][0]: 19, row[0][1]: Canon row[2][0]: 25, row[2][1]: HP Search String: Sony's Cyber-shot DSC-S600 End Result: 13 ...
Please dump these data first CREATE TABLE IF NOT EXISTS `all_tag_relations` ( `id_tag_rel` int(10) NOT NULL AUTO_INCREMENT, `id_tag` int(10) unsigned NOT NULL DEFAULT '0', `id_tutor` int(10) DEFAULT NULL, `id_wc` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id_tag_rel`), KEY `All_Tag_Relations_FKIndex1` (`id_tag`), KEY `id...
Why does SELECT OFFSETS(Data) FROM Data WHERE docid = 1 AND Data MATCH 'term' take same time as SELECT OFFSETS(Data) FROM Data WHERE Data MATCH 'term' And how can I make it work fast, i.e. just for one record? Thanks! ...
Hi. I'm currently looking for a way to search a big database (500MB - 10GB or more on 10 tables) with a lot of different fields(nvarchars and bigints). Many of the fields, that should be searched are not in the same table. An example: A search for '5124 Peter' should return all items, that ... have an ID with 5124 in it, have 'Peter'...
lets say I have a table with product details. one of the fields is category (integer). I want to do fulltext search on product name in specific category. Unfortunately Mysql does not allow me to specify index that includes category and product name as fulltext. It looks like I can use fulltext only on product_name and theefore any ful...
Hi guys, suppose someone enter this search (on an form): Nicole Kidman films Which SQL i can use to find "the best" results ? I suppose something like this : SELECT * FROM myTable WHERE ( Field='%Nicole Kidman Films%' OR Field='%Nicole%' OR Field='%Kidman%' OR Field='%Films%' ) My question is how to get most relevant result ? ...
Oracle's NEAR operator for full text search returns a score based on the proximity of two or more query terms. For example: near((dog, bite), 6) matches if 'dog' and 'bite' occurs within 6 words. What if I'd like it to match if either 'dog' or 'cat' or any other type of animal occurs within 6 words of the word 'bite'? I tried: ...
I have two same databases one on SQL Server 2005 and one on SQL Server 2008, it have same SQL_Latin1_General_CP1_CI_AS Collation, and full text search catalogs have the same settings. These two databases contains table with same data, NTEXT string: "...kræve en forklaring fra miljøminister Connie Hedegaard.." My problem is: CONTAINST...
Hi. I'm trying to understand the performance of an SQL Server 2008 full-text query I am constructing. The following query, using a full-text index, returns the correct results immediately: SELECT O.ID, O.Name FROM dbo.EventOccurrence O WHERE FREETEXT(O.Name, 'query') ie, all EventOccurrences with the word 'query' in thei...
I am new to FullText Search. Can anyone explains me Fulltext Search in SQL Server 2008 Step by step Thanks ...
the extracted source is below Showing /usr/lib/ruby/gems/1.8/gems/actionpack-2.3.5/lib/action_controller/templates/rescues/diagnostics.erb where line # raised: private method `gsub' called for #<NoMethodError: undefined method `closed?' for nil:NilClass> Extracted source (around line #): RAILS_ROOT: /home/sharath/Desktop/RORWorkspa...
I am developing a search engine. I am thinking about taking unique words from , lets say descriptions of products, and making a call to an API to get synonyms and index them also. "fast and powerful laptop" would yield the following results... of course "fast and powerful laptop" AND another field with "accelerated capable netbook" ...
I need to create a search index for a collection of HTML pages. I have no experience in implementing a search index at all, so any general information how to build one, what information to store, how to implement advanced searches such as "entire phrase", ranking of results etc. I'm not afraid to build it myself, though I'd be happy t...
I'm trying to do MySQL fulltext search using the following query: SELECT * FROM files WHERE MATCH(title) AGAINST ($q) limit $limit The problem is, if any words under 4 characters are included in the search phrase than it ignores them. This is very bad for my search engine because a lot of possible things people will be searching for w...