I am working on a database that is very localized, for example sake: Tables: Product - Has non localized columns (item number, created, etc) Product_Local - Has localized columns (description) and a language identifier column I am using SQL 2008 and full text searching requires for its word breakers that I set the language per column. ...
I use Full-text indexing in SQL Server 2008. I can't seem to find an answer to this question. Say that i have a full-text index on a table with the columns "Name" and "Description". I want to make the "Name" column much more important then the "Description" column. So if you search for "Internet" the result with the name "Internet" wil...
I was hoping someone could give me some advice, I am hoping to implement a full site search on a website that I building with codeIgnitor, PHP and mySQL. I was hoping someone would be able to over me some advice on wheather there are any free API's that enable a full site search, or any tips on building my own, how would be the best way ...
Hi , is there any way to Query the Index of Zend_Search_Lucene for an exact match ? $keyword = 'Summer 2009'; when i use : $myIndex->find($keyword) i am also receiving "Summer , 2009, Summer 2009" ? ...
How can I do a Filter across multiple fields in Lucene.Net? On one field I simply do: TermQuery tool = new TermQuery(new Term("Tool", "Nail")); Filter f = new QueryFilter(tool); If I now wanted to add a nail length to the filter, how can I do that? Also, I want the user to be a able to do a search with no search term (i.e. by just c...
I have 3 tables, and I want to make a query for a search term textbox. My query currently looks something like this: SELECT Artist.* FROM Artist, Band, Instrument WHERE MATCH (Artist.name) AGAINST ('mysearchterm') OR MATCH (Band.name) AGAINST ('mysearchterm') OR MATCH (Instrument.name, Instrument.description) AGAINST ('mysearchterm'); ...
I need a way to search through 50+ columns, both varchar and int, in a specific table. I've seen people recommend Lucene and Sphinx, but I have no clue how to go about using those and MySQL's Full-Text won't allow me to combine more than 16 columns or both varchar and int columns. ...
Does MySql full text search works reasonably with none Latin languages (Hebrew, Arabic, Japanaese...) Addition: Did some tests... It has some problems with Hebrew. Example: The name מוסינזון is pronounced the same as מושינזון but searching one won't find the other, as this is a common spelling error in Hebrew, it seems I will have to...
Say I have multiple blocks of the following code in a file (spaces is irrelavent): sdgfsdg dfg dfgdfgf ddfg dfgdfgdfg dfgfdg How do you find/highlight all the occurrences? What I ideally want to do is to visually select the code block and then press search to find all occurrences. ...
I have built a T-SQL query like this: DECLARE @search nvarchar(1000) = 'FORMSOF(INFLECTIONAL,hills) AND FORMSOF(INFLECTIONAL,print) AND FORMSOF(INFLECTIONAL,emergency)' SELECT * FROM Tickets WHERE ID IN ( -- unioned subqueries using CONTAINSTABLE ... ) The GUI for this search wi...
Here's the problem -- I have a few thousand small text snippets, anywhere from a few words to a few sentences - the largest snippet is about 2k on disk. I want to be able to compare each to each, and calculate a relatedness factor so that I can show users related information. What are some good ways to do this? Are there known algorit...
I am using SQL Server 2008 Full Text capabilities for the first time. I like the features that CONTAINS and CONTAINSTABLE offer, but I don't expect my users to learn the syntax for looking for inflections, using phrases, proximity, etc. My GUI will have a single text box to search with. Is there anything (.net DLL or c# code) out there ...
I have the following query SELECT ct.Id,rankdegree FROM (SELECT c.[KEY] as ID ,c.[RANK] as rankdegree FROM CONTAINSTABLE( dbo.SearchItems,*,N'FORMSOF(INFLECTIONAL,хорошую)',1000) as c) as ct where rankdegree>0 Table SearchItems contains some Russian text. "хорошую" is a russian adjective which means good. So the problem is t...
I've never done searching from MYSQL before, but I need to implement a search. I have three tables, 'articles', 'articles_tags', and 'tags'. 'articles' holds the first thing I would like to search on, the 'title' field. 'articles_tags' is a pivot table which relates 'articles' and 'tags' together. 'articles_tags' has two fields: 'arti...
Hi friends, i want to write a query with Full-Text-Search on a column with varbinary(max) type that stored a .doc/.docx(MS-Word) file. my query must returns records that contain a word in stored file. is this possible? if yes,how?(please write an example) if yes,can we write that for other language(e.g Arabic,Persian or a UniCode char...
hi friends i created a FTS by this article i have a column with type of varbinary(max) that i filled it with MSWord file(.doc) and another column with type of word(filled by .doc). when i run this script , the output is empty SELECT name, content FROM tblWordFiles WHERE FREETEXT(content, '1'); or SELECT name, conte...
I'm developing a high-volume web application, where part of it is a MySQL database of discussion posts that will need to grow to 20M+ rows, smoothly. I was originally planning on using MyISAM for the tables (for the built-in fulltext search capabilities), but the thought of the entire table being locked due to a single write operation m...
I've been using Zend and need a search. The Zend docs aren't great so I had a couple questions that are easy to answer but not directly obvious. I'm using Lucene to search an SQL database How do I associate the index of my item with the text of that item. So if they search and find the item, how do I get its index returned? As far ...
At MSDN I read: < prefix_term > Specifies a match of words or phrases beginning with the specified text. Enclose a prefix term in double quotation marks ("") and add an asterisk (*) before the ending quotation mark, so that all text starting with the simple term specified before the asterisk is matched. Well, tha...
I'm looking for search engines that will run on one or more of the mobile platforms listed in the title. Something like Lucene (which 'should' run on Android) or minion. What are my alternatives on each platform? Have you made them run? What are the limitations you stumbled upon (cannot index more than 20 megs, for example)? ...