OK this is the situation.. I am enabling fulltext search on a table but it only works on some fields.. CREATE FULLTEXT CATALOG [defaultcatalog] CREATE UNIQUE INDEX ui_staticid on static(id) CREATE FULLTEXT INDEX ON static(title_gr LANGUAGE 19,title_en,description_gr LANGUAGE 19,description_en) KEY INDEX staticid ON [defaultcatalog] WIT...
I'd like to implement fulltext search for a datatable ? are there any .net libraries which support indexing/searching on the fly ? ...
Hello, I have a question regarding a CONTAINSTABLE function. I would like to find everything that ENDS WITH the search string. I can use the * to find everything that starts with the searchvalue, but I want an equivalent for the % sign in the SQL LIKE function. What I want: find everything that ends with 123, so as searchvalue, I coul...
I have an application running on mssql 2005 express and I want to install the full text search. What should I do? Can I download the full text search service and install it separately. ...
Probably a noob question, but I'll go for it nevertheless. For sake of example, I have a Person table, a Tag table and a ContactMethod table. A Person will have multiple Tag records and multiple ContactMethod records associated with them. I'd like to have a forgiving search which will search among several fields from each table. So I...
Hi! I have used full text search mysql. My code is select * from uh_property WHERE match(fieldname) against('serach_word') Now when i type word of three character search record is not displayed. For example i have record with name 'eco'. When i type eco in text box for search no record displayed. I found that minimum characte...
Hi all, I've been looking into searching plugins/gems for Rails. Most of the articles compare Ferret (Lucene) to Ultrasphinx or possibly Thinking Sphinx, but none that talk about SearchLogic. Does anyone have any clues as to how that one compares? What do you use, and how does it perform? ...
I have a products model set up that I am trying to search with Thinking Sphinx. The model has an attribute called status which can be Active, Not active or Active during specified dates. I would like to be able to restrict my search results to products that are active. I.e. has status of active or has status of active during dates and ...
Hi! I am doing a web-project based on asp.net mvc framework. As db I am using postgre SQL. The question is how to organize searching in my application. One option would be using of .net libraries such as lucene.net. Another option is to use the Postgre full text search. So what is the best option? ...
I have a SQL Server 2005 Full-text index with the language set to Neutral. I've edited the stop word list to remove single-digit numbers and rebuilt the index. If you search for any single digit (using contains), it ignores the number. 2 or more digit numbers work fine. Any ideas? ...
Hello, I was wondering if SQL Server is actually utilizing its fulltext index on searches that can be in the middle of text (such as LIKE %searchKeyword%)? I forgot where I read it, but I did read somewhere that the fulltext index would only be utilized when it is used in a "StartsWith" manner (searchKeyword%) where you search for a LIK...
The nice wizards says If this is a large table or view, or if the chosen full-text catalog has indexed or other large tables, consider assigning this table or view its own full-text catalog "Large" is a pretty subjective term, is it 1000 records or 1,000,000 in a table? What guidelines do you follow when creating additional full-t...
Hi, I recently found out that you can get information about the index of a table using sys.dm_fts_index_keywords (SQL Server 2008 Express). I was surprised when I saw that 0xFF "END OF FILE" has the most occurrences of all the terms in the index (document count = 2730). Is that normal? What about disk space: Does the index store referen...
I am looking to learn more about full text indexing and I am looking for more information than is available in SQL Books online or at least something that presents full text indexing in a different way. Does anyone have any recommendations on books. ...
Hello everyone, I am asked to either deploy or develop an enterprise (intranet) search engine which could index all web pages of a couple of internal servers, and have a search portal to display all related content, like what Google is doing but for intranet. Any advice how to develop or deploy quickly? I have heard of Microsoft FAST p...
This is basically implementing search/find in a WPF window or User control. Let's say you have a WPF window with dynamic readonly text some on textblock, some in a listbox, some in treeview, some in textblocks etc. The user should be able to type in a search term in a textbox on the top and be able to see it highlighted wherever and in ...
I have a site that lists movies. Naturally people make spelling mistakes when searching for movies, and of course there is the fact that some movies have apostrophes, use letters to spell out numbers in the title, etc. How do I get my search script to overlook these errors? Probably need something that's a little more intelligent than...
I have a product table that contains thousands of products. Some products are available in different colors. But when somebody searches for example 'mp3 player' i dont want to show him every color, instead just the player with the best selling color. Her is the table layout (simplified): ID | PRODUCT_NAME | COLOR | SALE_COUNT ====...
I'm using MSSQL's full text indexing on a handful of tables in my CMS and am unfortunately stuck with SQL Server 2000. I'm querying the index using freetexttable joins and am having pretty good results, but we have some unique terms that are likely search queries that do not appear to be stemming. For example a query using the term "sm...
I had a working FREETEXTTABLE query that searched for a @searchString. I now need to UNION that with another simple query that tries to parse the @searchString into an INT, and if it succeeds, filtering the table by looking for the row with PK equal to the parse @searchString. Previously, I could easily JOIN the FREETEXTTABLE result to ...