Hoping someone can provide some mysql advice... I have 2 tables that look like this: searchTagsTable ID tag dataTable ID title desc tagID So the column "tagID" in "dataTable" is a comma-delimmited string of ids pointing to searchTagsTable. I'd like to use mysql's built in fulltext search capabilities to sear...
Hi, I want to move full text catalogue for 1 database to a different location on same SQL server. I am using SQL 2005. One of the source said: SQL Server 2005 full-text search provides the ability to easily detach and move full-text catalogs in the same way that SQL Server database files may be detached, moved, and re-att...
Is there any case study available of any project that uses PostgreSQL 8.3+ Full Text Search on a large amount of data? ...
I have an asp.net web page with a simple search text box that returns matching rows from a MSSQL 2005 database. It is currently using a LIKE statement to bring back matches, but forces the user to to type an exact phrase. Users want a more Google search type experience and so I have decided to set up and index the needed tables with FTS....
Is there a way to determine if a MATCH query sent to an fts3 table in sqlite is valid? Currently, I don't find out if the expression is invalid until I try to run it, which makes it a little tricky. I'd like to report to the user that the syntax is invalid before even trying to run it. I'm using sqlite with the C api. Additionally, do...
What's the secret to pulling up items that match characters typed into the search bar that react instantaneously? For instance, if I type in a letter "W" in the search bar, all phrases that contain a letter "W" in any character position within the phrase are returned immediately. So if a database of 20,000 phrases contains 500 phrases w...
I have 2 tables nsk_UserInfo and Photos. I use full text search query to show result SELECT nsk_UserInfo.User_ID , nsk_UserInfo.Name , nsk_UserInfo.Contact_Person , nsk_UserInfo.Address, Photos.Photo1 as 'Photo' FROM nsk_UserInfo INNER JOIN Photos ON nsk_UserInfo.User_ID = Photos.User_ID WHERE FREETEXT ((nsk_UserIn...
Has anyone done any performance measures with this in terms of speed where there is a high number of substitutes for any given word. For instance, I want to use this to store common misspellings; expecting to have 4-10 variations of a word. <expansion> <sub>administration</sub> <sub>administraton</sub> <sub>aministraton</sub> <...
I am looking for a very robust software search engine to integrate in a .Net web site. The current proposed solution is Lucene.NET a stack based on Lucene. However, I would like to evaluate other search engines before making my mind up. The feature set we need is the following: Ability to crawl arbitrary pages via HTTP Ability to pa...
I am about to launch a beta site, and heroku looks like a great option. The only think that is getting me down is that the only search option is $20/mth for the Websolr add-on. I am sure that Websolr is great, but at this very early point in this project, I rather not light up that expense. Are there any free search options to couple ...
Does anyone know of companies offering SaaS full text search? I'm looking for something that uses Lucene, solr, or sphinx on the backend, and provides a REST API for submitting documents to index, and running searches. I could build my own EC2 AMI, but I'd have to configure EBS and other stuff, monitor it, etc. Curious if someone has ...
Is the following SQL susceptible to SQL injection via the @SearchWord parameter? I want to use parameters with the FormsOf function, but the only guide to doing so I've found is in this Stack Overflow question: http://stackoverflow.com/questions/1362220/how-to-pass-parameter-to-formsof-function-in-sql-server However the solution seems ...
I have one table and I want to create two fulltext catalogues, one in German, and one in English. My problem is: I can only create one fulltext catalog per table, but I want to create a fulltext catalog for English language and German language. I cannot use an indexed view. Is there any way to fix my problem? ...
Hi, we have a table with +- 500k rows in Sql Server 2005 database and one of its columns has a full-text index. We were doing some tests and found that SELECT TOP 1 ... WHERE CONTAINS(fullTextColumn, 'anyValue') was taking more than two minutes to return. However the same select, but with TOP 2 instead of 1 return in a few seconds. A...
I have a fulltext catalog for an indexed view. Problem: I want to search with the function 'FREETEXT' all words which contains the search term. But the result doesn't return any entries... but one entry must be the word 'freightcosts' If the search term = 'freightcosts', the result is 'freightcosts'? Example: SELECT [Description] ...
I have a requirement to find rows in a table containing 200,000 entries. Some may not consider this 'large', but it is large enough to warrant performance considerations. The table contains strings consisting of digits only. For instance, the user can enter something like '12340-0560-78', or portions of this, e.g. '0560', and I need to ...
How-tu use NHibernate (with Fluent NHibernate) with SQL Server Full Text Search ? Thanks ...
I am attempting to setup a full text search catalog in SQL Server 2008 is there a way to make this catalog contain data from multiple tables? ...
Hey, I have a table of news, and I want to allow the user to search in it. Something like this: News.Where(p => p.Title == user_query); ...that will allow more advanced queries, like Differences Between "Linq to Objects" and "Linq to SQL" queries, etc. Also it should be incase-sensitive. Any ideas? Thank you. ...
I have a list of books listed by their titles in a text file. I want to write a script which can use a web service like Google scholar or amazon to search for the books and return me a xml or bibtex file with citation info for each book. Which programming tools can I use for this kind of automated search ? ...