I have a survey that's stored in a large object graph of variable depth, depending on how many sections and sub-sections the user chooses to create. I need to be able to search through all the properties for each object in the object graph and see if that property's .ToString() contains a certain keyword that's being searched for. Can I...
Hello all I am creating a webapp in Cakephp, and am thinking of implementing a search function in it. I read about Zend Lucene providing the search capabilities for native PHP webapps. I have my web pages all created without using any kind of database functionality. How will I able to add webpages to the indexes? I don't mean the code,...
I am trying to join multiple tables and perform a full text search on them. Most of the tables are unrelated but have similar fields. I have had the fulltext searches working but i need to be able to create links from the results which is the next step but i don't thin k it will work becuase i haven't got enoygh fields to get enough i...
Possible Duplicate: How to install fulltext on sql server 2008? I have recently installed SQL Server 2008 R2 When I tried to create Full Text Search Index Example CREATE FULLTEXT INDEX ON DATABASENAME.dbo.MYTABLE ( column_to_index Language 0X0 ) KEY INDEX myindex ON DATABASENAMECatalog WITH CHANGE_TRACKING AUTO It had giv...
I want to convert user typed FTS queries in to MySQL's WHERE clause. So the functionality will be something like Gmail's search. So users will be able to type: from:me AND (to:john OR to:jenny) dinner Although I don't think it is important, the table structure will be something like: Message - id - from - to - title - descriptio...
My sql statement SELECT * FROM mytable WHERE (CONTAINS(keyword,' "green" ')) How do I list the top matched result like this Green Army Green Hunter Green instead of the below Army Green Green Hunter Green I know that we can't use the order by asc or desc with my case. I plan to add a space before 'green' and use the dict...
Can I choose to ignore the tsENU.xml thesaurus file in a full-text query in SQL Server 2005? IF @x = 0 THEN BEGIN SELECT FROM FREETEXTTABLE(use subtitutions and expansions in thesuarus) END ELSE BEGIN SELECT FROM FREETEXTTABLE(just match based on the exact query terms, no thesuaurs) END ...
I've read about full-text search functions in mysql. But in these methods you have to search for exactly right spelled complete words. For example if your text contains 'Bitdefender 2009' and you search for Bit, you get nothing SELECT * FROM logs WHERE MATCH (log) AGAINST ('Bit 09' IN BOOLEAN MODE); So are there any solution for this...
I am implementing a full text search using a view vw_SearchSite which has all the searchable fields and returning sites which have site IDs in common with the search results. the query: ..... SELECT DISTINCT {site.*} FROM v_Site {site} WHERE {site}.Id IN ( SELECT Id FROM vw_SearchSite WHERE CONTAINS(vw_SearchSite.*,:p...
Hi Does anyone have information on how to create a custom word breaker for SQL Server 2005. I'd prefer to write it in c#. I need to be able to search on terms such as 'c#', 'f#' etc but the '#' character is a word breaker in the English (UK) word breaker component and can't be changed in any other way. I have found the following articl...
We are searching disparate data sources in our company. We have information in multiple databases that need to be searched from our Intranet. Initial experiments with Full Text Search (FTS) proved disappointing. We've implemented a custom search engine that works very well for our purposes. However, we want to make sure we are doing ...
if anyone has ever submitted a story to digg, it checks whether or not the story is already submitted, I assume by a fuzzy search. I would like to implement something similar and want to know if they are using a php class that is open source? Soundex isnt doing it, sentences/strings can be up to 250chars in length ...
I have a situation where I would like to search single word. For that scenario, which Query would be good from performance point of view? Select Col1, Col2 from Table Where Col1 Like '%Search%' Or Select Col1, Col2 from Table Where Col1 CONTAINS(Col1,'Search') ...
I have some search queries like so: George AND NOT Washington OR Abraham Dog OR cat AND NOT Wolf for these searches I would want to get back results for George or Abraham but not Washington, etc. basically I want to take the string and be able to submit a contextual search to my full-text catalog stored procedure search. I ...
Greetings Overflowers, I'm wondering if there is a way to query some kind of a database and only fetch a certain window in the full result set without having to actually go through them all. For example, if I query my database and I want only results number 100 to 200, would the database fetch all the results (say 0 to 1000) that match...
In my Job listings site, I need to show jobs which have similar titles to the one which is being viewed. I am trying the following query, but its not working: SELECT *, MATCH(title) AGAINST "Sales Coordinator" as relevance FROM jobs WHERE MATCH(title) AGAINST "Sales Coordinator" ORDER BY relevance DESC LIMIT 100 Also, can this b...
I have a news site with 150,000 news articles. About 250 new articles are added daily to the database at an interval of 5-15 minutes. I understand that Solr is optimized for millions of records and my 150K won't be a problem for it. But I am worried the frequent updation will be a problem, since the cache gets invalidated with every upda...
When I read the Lucene.net docs, the only analyzer that I find is the standard one. I want to make sure I can do Phonetic or Aproximative search on my index. Is there some extra library I should use on top of Lucene.net? ...
Hello, I need to filter stream of text articles by checking every entry for fuzzy matches of predefined string(I am searching for misspelled product names, sometime they have different order of words and extra non letter characters like ":" or ","). I get excellent results by putting this articles in sphinx index and performing search...
Is there a way to escape the * character in a full text Contains function in sql server 2008? I've tried a standard escape by using square brackets, but that just throws a syntax error. Also, any solution can only use full-text functions as the column I'm searching is an image/blob column. ...