i am using sql server 2005 i have a stored procedure which searches database with containstable method the problem is when i search some prefix with '*' character i can't see the records which have full word just records with only prefixes. for example i search 'some' then set my variable to 'some*' and i have 'some' and 'something' reco...
Our application allows a user to enter company names that their organization works with. A current issue is that the way one user inputs the company name varies from user to user. We need to consolidate this data. Are there any proven approaches for tackling this problem? ...
I'm using sphinx and thinking sphinx to search a customer database. The customer metadata (emails, tels etc) are spread across multiple tables and sphinx indexes all notes on customers etc etc. The problem I'm having is that I want text fields which START with the search term to be displayed first in searches. i.e. a search for "hods" sh...
Hi guys I have a problem with a FTS on SQL Server 2008. First I am not an expert in that field. The problem is as following. I have a row with column value 'This is it aka Michael Jacksons's This is it'. When user enters in a search box term "This is it" following query returns 0 results. SELECT column_list FROM tabla_name...
Iam using fulltext search in my php file using mysql.But its not giving any result for integers like "Timber Jane 10". My requirement is to get exact search, that is, if I search a full name it should give exact matches which contains those words and in the order of best match in descending order no matter if the searched phrase is a t...
I develop news search engine with C# and SQL Server 2008 i using SQL Full text search for search and it's ok until some week ago. currently i have more than 100 million record, that daily added about 1 million article. but i see sometimes when user search, one of 8 CPU become 100% and take some minutes. after repopulate catalog, it's o...
I have a normalized sql server 2005 database. An example of a table that is something like this: Location LocationID, CustomerID, OrderID This is abbreviated. However, the normal query syntax simply uses joins to show the location as city state zip and the name of the customer and so on. I would like to implement full text search on...
I asked this question about a year ago on another site but never got the answers I was looking for. And I've been wondering about it ever since. I'd like to impliment some search functions similar to Google's (inurl:foo, site:bar.com) So if you entered a normal query, with none of these functions included, it would search one column. ...
Does Android come with a way to do Full Text Search? I know is it not even possible to search contacts by the notes field, being Google the search company, but I would be disappointed if there is no API for that. ...
I would like to implement full-text-search in my off-line (android) application to search the user generated list of notes. I would like it to behave just like Google (since most people are already used to querying to Google) My initial requirements are: Fast: like Google or as fast as possible, having 100000 documents with 200 hundr...
I was using the return value of fgrep -s 'text' /folder/*.txt to find if 'text' is in any .txt file in /folder/. It works, but I find it too slow for what I need, like if it searches for 'text' in all the files before giving me an answer. I need something that quickly gives me a yes/no answer when it finds at least one file with the 't...
Is it possible to use hibernate search/lucene to index some entity based on values of some fields? For example, let's take the following example: A product has several properties with values. e.g. property names could be color, amount, order-date, price, whatever... PRODUCT ( name description ... ) PROPERTY ( id nam...
Can anyone show me an example of how PhraseQuery works in Lucene.Net. I am building an utility that will scan through the Lucene index created from thousands of word, rtf documents and will search for EXACT match of lines. For example, if i search for "the quick brown fox jumps over a lazy dog", the search should return the number of...
I have a database full of phrases (80-100 characters), and some longish documents (50-100Kb), and I would like a ranked list of phrases for a given document; rather than the usual output of a search engine, list of documents for a given phrase. I've used MYSQL fulltext indexing before, and looked into lucene, but never used it. They bot...
I'm using Solr for search. I have documents that have an integer field "popularity". I want to rank results by a combination of normal fulltext search relevance and popularity. It's kinda like search in digg - result ranking is based on the search relevance as well as how many digs a posting has. I don't have any specific ranking a...
Hi All, I have an application that converts Word Document to PDF automatically. The issue is I am not able to use Full Text Search in the converted PDF. Whereas I can search in pdf if it is converted through Microsoft Word Application. Thanks in Advance for you support. ...
Simple question: does SQLite support FULL-TEXT searches? If not, is there any way I can implement that feature? ...
I need to provide some kind of global search over most of the data that my application have. The data is distributed in different tables, like users, comments, etc. in MySQL. I do want to handle this in the application, not with something like Google Custom Search. My idea is to create table, which would have columns like source id and...
Consider following assumptions: I have Java 5.0 Web Application for which I'm considering to use Lucene 3.0 for full-text searching There will be more than 1000K Lucene documents, each with 100 words (average) New documents must be searchable just after they are created (real time search) Lucene documents have frequently updating inte...
I'm often working with undocumented code. Much of the time, PHPxref works great for this, but often there's code that isn't a php variable or function, so PHPxref won't search for it. For example, right now I'm working with Smarty templates, and it's not straightforward to search for the smarty variables in the rest of the code. A sea...