Questions tagged [full-text-search]
Searching the text of a collection of documents or free text fields in a database to find those containing a word or combination of words.
609
questions
2
votes
1
answer
4k
views
How to search double quotes in fulltext search in sql
I have double quotes in my Keyword. How can I search this in my fulltext search query. I have this query
SELECT top 10 K.[KEY], 10, K.[RANK]
FROM CONTAINSTABLE(ProductKeywords, Keywords, '("19*") ...
- 121
1
vote
1
answer
652
views
DTC Timeout when trying to update oracle table through link that contains a text index
Problem
Given is a SQL Server connected to an ORACLE Instance as a Linked Server. It’s using the Oracle Client OLEDB Provider. When doing an update in a transaction on a table having a CTXSYS.CONTEXT ...
- 11
2
votes
1
answer
287
views
Elasticsearch and product characteristics
I have a small question about elasticsearch. Let's say I have a database with products to sell, like an ecommerce.
I know that elasticsearch can help me to find the best product with, for instance a ...
- 177
5
votes
2
answers
3k
views
MongoDB text index and text search
I have a MongoDB collection db.articles,it has 2 keys ,"title" and "abstract".I want to do text search on these two keys.For example, the search text is "physics",and I want all the documents whose "...
- 363
0
votes
2
answers
1k
views
DBI1011I Error when using db2iupdt to enable Text Search
I'm trying to enable Text Search in my DB2 instance. I'm running this command:
# /opt/ibm/db2/V10.5/instance/db2iupdt db2inst1 -j "TEXT_SEARCH,db2j_db2inst1,55000"
I get this error:
DBI1011I An ...
- 135
1
vote
1
answer
1k
views
Rebuild the Fulltext catalog
I have a Database (80GB) that is able to store attachments. These attachments are full text indexed. For some reasons I had to rebuild the fulltext catalog and this took 30 hours.
Our business users ...
- 337
0
votes
2
answers
1k
views
What is the best partition technique for large table with TEXT column?
MySQL: What is the best partition technique for large InnoDB table (around 1.5M rows) with TEXT type of column?
There is a FULLTEXT index on the TEXT column, which is very essential for my searching ...
- 1
2
votes
0
answers
214
views
SQL Server Full-Text Index with Stoplist
I've searched this site and the internet in general and can't find any information which answers my question, so I thought I'd post it here. I have Full Text search operating on a database in SQL ...
- 141
6
votes
3
answers
2k
views
SQL Server Full Text Search - .rtf files incorrectly indexed by rtf tags
I've set up a full-text index on my SQL Server DB on a varbinary(max) column. I have a type column specified, which contains the extension of the file, such a ".doc", ".pdf" etc.
However, I have ...
- 163
5
votes
4
answers
6k
views
How do I use an Ispell dictionary with Postgres text search?
Postgres can use Ispell-compatible dictionaries in text search, but does not provide the required files.
- 8,463
5
votes
1
answer
6k
views
PostgreSQL FTS and Trigram-similarity Query Optimization
I have recently started working on PostgreSQL and I have around 12M rows to handle in which I want to apply Full Text Search. I don't have any prior experience in handling such databases. I have tried ...
- 161
-2
votes
2
answers
642
views
SQL Server 2012 - Stopword Error [closed]
I am doing an exercise in Microsoft 70-461 certification book (written by Itzik Ben-Gan)
In chapter 6-Query Full text data. I run the following query to create a stopword list.
The system showed me ...
- 215
1
vote
1
answer
2k
views
Prefix full text search with numbers in SQL Server
If I create the following table in SQL Server 2008 R2:
CREATE TABLE test(
id BIGINT IDENTITY NOT NULL,
value VARCHAR(10),
CONSTRAINT test_pk PRIMARY KEY (id)
);
CREATE FULLTEXT CATALOG ...
- 171
1
vote
1
answer
854
views
Language difference in full text search for numeric strings
If I create this table on SQL Server 10.50.2550 (SQL Server 2008 R2):
CREATE TABLE test(
id BIGINT IDENTITY NOT NULL,
number VARCHAR(10),
CONSTRAINT test_pk PRIMARY KEY (id)
);
CREATE FULLTEXT ...
- 171
2
votes
1
answer
10k
views
MySQL Regex matching newline or end of string
I have a text column in mysql which contains some values separated by a newline. I want now to query by these values and thought a regex should help me with that by doing something like:
SELECT * ...
- 171
2
votes
1
answer
1k
views
SQL Server Full-Text Search: combining proximity term and thesaurus
Scenario
I am developing a full-text search over a products table.
The full-text indexed field of th table contains a brief description of the product, the name of the category and the product code.
...
- 359
3
votes
2
answers
6k
views
How to repair all indexes in a MySQL database?
My database got corrupted, and now the php app is throwing this error:
Invalid query: Can't find FULLTEXT index matching the column list
The error is not very useful, since it doesn't say what ...
- 131
1
vote
2
answers
881
views
to use full text search or not?
In my web app, I have a web page for admins that displays the following fields:
user id (numeric)
device id(numeric)
device description (text)
cell phone number (text)
user name (string ... but ...
- 751
2
votes
1
answer
10k
views
mysql match against boolean mode
I'm using MATCH AGAINST in boolean mode to add a simple search functionality to my site.
The column to be searched is varchar, with no full text index. The column value can be alphanumeric, all ...
- 259
1
vote
0
answers
806
views
SQL Server full text indexing disabled
I have a SQL Server 2008 R2 server instance where I'm unable to use full text catalogs. It was upgraded from SQL Server 2008. When I go to the database properties of an existing database or try to ...
- 111
1
vote
1
answer
2k
views
SQL Server 2012 - Full Text Search [Break word - Underscore]
Let's say I want to search for a list containing 'PS3':
SELECT * FROM [TABLE] WHERE CONTAINS(Title, 'PS3')
When the Title is proceeded by an underscore it will not return it.
Oblivion-PS3 -> Good
...
- 111
5
votes
4
answers
6k
views
Sql server full text search performance with additional conditions
We have a performance problem with SQL Server (2008 R2) Full text search. When we have additional where conditions to full-text search condition, it gets too slow.
Here is my simplified query:
...
- 151
1
vote
2
answers
321
views
Designing a user table, FName LName v.s Username
I did some research on different ways of getting user's name. Some database designers prefer to have a username that contains first name and last name with space separator, and some other designers ...
- 13
2
votes
1
answer
533
views
Sphinx: Indexer causes MySQL to hang
Not sure what's going on. I run indexer --all --rotate
When it finishes mysql hangs and not accepting new connections.
from my observation as soon as indexer finishes, all update,insert,delete ...
- 141
1
vote
1
answer
1k
views
ERROR: text search configuration name "english" must be schema-qualified [closed]
Trying to do some full text searching with postgres and when running the following command
UPDATE "EMAIL" SET PostText = to_tsvector('pg_catalog.english', "TEXT");
I'm getting the error:
ERROR: ...
- 115
-1
votes
2
answers
154
views
How do I avoid duplicate rows using FREETEXT?
I have the following query:
SELECT
cat.CategoryId,cat.CategoryName,cat.CategoryImageURL,cat.CategoryImageData,
ap.AppName,ap.AppImageData,ap.AppDetails,ap.AppId
FROM Category cat,App ap
WHERE ...
- 113
1
vote
1
answer
1k
views
Full-text Search XML Properties
I'm trying to determine whether I can retrieve a property (attribute) value from an xml blob stored in a FILESTREAM-enabled column using Full-text search. Here is a sample where message is a ...
- 774
1
vote
0
answers
523
views
Fulltext search returning too many rows
Server: MySQL 5.1.66-0+squeeze1
My problem:
I have two databases with the same tables. One is for the testing environment and one for production. When I perform a MATCH AGAINST on the prodution ...
- 111
7
votes
1
answer
3k
views
Full text search through many tables in MySQL
We have high traffic NEWS websites, I want to add a feature that every user can search through over all content of site, such as news, polls, comments, galleries,etc . Each of contents type has its ...
- 663
0
votes
1
answer
2k
views
Does full text search works with characters?
I have successfully created an FTS index on a column where we have stored the name of medicines e.g:
Amoxicillin 250mg capsules 21 capsule
Verapamil 160mg tablets 100 tablet
When I search with the ...
- 37
2
votes
1
answer
1k
views
FTs catalog in SQL Server for multiple FT index
I have created one catalog for FTS index, can the same catalog be used by by another table in index.
- 37
0
votes
2
answers
469
views
Full text catalog does not allow me to hit on singular forms
I have created a full text catalog for a column under database name -> "Storage" -> Full Text Catalogs. It is accent sensitive and "default catalog" is set to false. The language for the column "...
- 664
0
votes
1
answer
1k
views
Full text query slow on first run [closed]
I have SQL Server database which has size of 65GB and 6 million rows. We have essays in tables and the average size of an essay is 450 words. When I run a query for the first time, it takes 3-10 ...
- 29
2
votes
1
answer
7k
views
Fixing wildcard expansion resulting in too many terms error (DRG-51030)
How can I resolve the wildcard_maxterm problem in Oracle 10g?
My index creation syntax is:
begin
ctx_ddl.drop_preference('SUBSTRING_PREF');
end;
/
begin
ctx_ddl.create_preference('...
- 21
7
votes
2
answers
8k
views
Installing Full Text Search to SQL Server 2008 R2
I installed sql server 2008 R2 Express successfully, then realised I need to get Full Text Search. So I downloaded the "Advanced Services Installation Package", but when I run it there is no option in ...
- 173
1
vote
0
answers
384
views
Mysql key_buffer_size already 16GB but some fulltext searches are still slow
I have a query w/ full text search which takes 5 - 10 secs. key_buffer_size is already 16GB.
Table has 15 million records and has a compound fulltext index on fields: categories and company.
Table ...
- 11
2
votes
1
answer
1k
views
Full-text Catalog Corruption
I have a SQL Server 2005 database that I backed up and restored onto a new server running SQL Server 2012. So far so good. This morning I had a really bad power outage and the new server went down. ...
- 163
2
votes
2
answers
7k
views
How do I rebuild single full text catalog (or why is "rebuild" full text catalog option disabled)
In SSMS. I have Full Text Catalog defined. If I select "Full Text Catalogs" folder - there is an option "Rebuild All" and it is enabled.
But if I select individual FTC - "Rebuild" option (in context ...
- 223
1
vote
1
answer
3k
views
What are safe characters to use in SQL Server Full Text Search? [closed]
I've been playing with full text search on SQL Server 2012. I must say my attempts to target special characters in search queries were futile - SS does not understand them. What's more, sometimes the ...
- 27
2
votes
2
answers
10k
views
MYSQL matching one column to another in a different table via a FULLTEXT index
I current have two different tables.
The first table has a list of titles and IDs associated to these titles; the second table is a list of random heading.
What I would like to know is if there is a ...
- 149
0
votes
1
answer
3k
views
Full text search on multiple tables in PostgreSQL
I have several tables that have related data. I want to have a search input box on the dashboard of the system that will search for anything (client, invoice, delivery note, ...).
Is it possible to ...
- 535
0
votes
1
answer
2k
views
Searching for keywords in fulltext indexes using the "contains" function
Lets assume "and" is not a stopword, in my language it should not be.
How do I search for it using the contains function?
It is a keyword, but how do I escape the keywordness?
No luck with:
SELECT ...
- 664
4
votes
2
answers
546
views
Fulltext search limiting users possibilities
We have a web site with a search box. The search uses a fulltext index column. However, we just cant feed the text the user has input into this stored procedure.
CREATE PROCEDURE [dbo].[SearchPages]
...
- 664
6
votes
1
answer
2k
views
Full-text search with german umlauts
I created a table using German (Germany) as the Full-text language, in the settings I tried setting accent sensitivity to both sensitive and insensitive. I, however, get following odd results.
The ...
- 61
1
vote
1
answer
892
views
Updating an FTS indexed column returns "Invalid InnoDB FTS Doc ID"
Environment:
Ubuntu 12.04 (and 13.04)
MySQL 5.6.11
I have a table which has a full text index on it (real table has much more columns and rows):
DROP TABLE IF EXISTS articles;
CREATE TABLE ...
- 113
5
votes
1
answer
1k
views
How much data can SQL Server full text indexing handle?
I realize that the question is vague and it depends on hardware and our needs.
We currently have 5 million rows of data, a total of 5GB of data which we want to index using full text indexing. Our ...
- 211
2
votes
1
answer
1k
views
Longest prefix search in Oracle
I have a list of phone number prefixes defined for large number of zones (in query defined by gvcode and cgi).
I need to efficiently find a longest prefix that matches given number PHONE_NR.
I use ...
- 123
3
votes
0
answers
275
views
custom population of full text index
Is there any way to populate a full text search index without storing the backing information in the database?
I don't mean using remote-blob-storage or FILESTREAM types. The backing information is a ...
- 343
2
votes
1
answer
72
views
Audit full text activity
I need to find when and which user created full text catalog, and who added/modified/deleted the columns (that were full text indexed) in that full text catalog.
- 21
0
votes
1
answer
118
views
Can I use the database and query it while full-text indexing?
I need to index my database, but I need to query it while it is indexing, it may take a long time, can I do that?
- 193