Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
4
votes
1 answer

MySql Fulltext search using 2 character word

I've set ft_min_word_len = 1 and running show variables like 'ft%'; also shows the same. Also have already updated the Fulltext indexes by dropping and re-creating them. But when I run SELECT OriginalProductName FROM products WHERE MATCH…
Libin TK
  • 1,477
  • 2
  • 25
  • 46
4
votes
1 answer

Having trouble using 'AND' in CONTAINSTABLE SQL SERVER FULL TEXT SEARCH

I've been using FULL-TEXT for awhile but I cannot seem to get the most relevant results sometimes. If I have an field with something like An Overview of Pain Medicine 5/12/2006 and a user types An Overview 5/12/2006 So we create a search like: "An"…
Joshua
  • 581
  • 1
  • 4
  • 8
4
votes
1 answer

Create full text index by querying for index name

I want to create a full text index but I am not sure if the index name is the same in all databases. So, I plan to write the below select and get the name of the index. DECLARE @keyIndex NVARCHAR(100) SELECT @keyIndex = name FROM sysobjects WHERE…
stech
  • 675
  • 2
  • 9
  • 22
4
votes
2 answers

postgres 9.1 full text search returning no results

I have searched on the web for many days by it seems the internet has never heard of my problem: I have a postal address database table holding about 37M records for United Kingdom, which has a geospatial index and a derived full text index created…
PowerAktar
  • 2,341
  • 1
  • 21
  • 17
4
votes
1 answer

Mixed queries against full-text index

I am using SQL Server 2012. A table has a text and a date column. The text column has a full-text index. The query issues CONTAINS against the full-text column but it also needs to include a greater-than condition on the date column. I am concerned…
user1044169
  • 2,686
  • 6
  • 35
  • 64
4
votes
1 answer

Add FullText Capability to existing table in MySql

Possible Duplicate: MySQL/PHP Search Efficiency How to Add FullText Capability to the existing table in MySQL. I've seen adding it directly at the time of table creation as follow. CREATE TABLE articles ( id INT UNSIGNED AUTO_INCREMENT NOT…
hungrycoder
  • 507
  • 2
  • 9
  • 24
3
votes
1 answer

When does MySQL rebuild a FTS index?

If you want to use the MySQL Full Text Search functionality you define a Full Text Index on field(s) with type VARCHAR. As rows are INSERTed and UPDATEd, mysql has to keep the indexes up-to-date. My question is: When does MySQL rebuild a FTS…
Tom
  • 14,041
  • 16
  • 64
  • 80
3
votes
3 answers

Performing searches against large dictionaries using php

Currently I am trying to perform text searches against large dictionaries using php or mysql. Until now I haven't found the best way to do that. For example there is a Text:Scan module written in Perl…
Nikola Obreshkov
  • 1,698
  • 4
  • 21
  • 32
3
votes
1 answer

MongoDB Atlas Search autocomplete index wrong scoring

I have a MongoDB Atlas Search index with the autocomplete type on a field name and the following attributes : maxGrams : 15 minGrams : 2 tokenization: edgeGram fold diacritics: true The collection contains the following names : The American The…
Jonathan Wadin
  • 81
  • 1
  • 6
3
votes
2 answers

Full-text Indexing for a view with multiple databases

Can MS SQL support full-text indexing for a view that connects (joins or unions) multiple databases?
BenMaddox
  • 1,780
  • 3
  • 18
  • 30
3
votes
2 answers

How to do fulltext search in multiple columns in MySQL, quickly?

I know this question has been asked several times.. but , let me explain. I have a table with 450k records of users (id, first name, last name, address, phone number, etc ..). I want to search users by thei first name and/or their last name. I used…
Jerry
  • 1,141
  • 1
  • 13
  • 18
3
votes
1 answer

SQL Server 2008 Repopulate Index "Update" Option

I have created a single catalog named EntryCatalog. I assigned a table named Entry to the catalog and selected Notes and Title columns (both nvarchar max) with Track Changes set to Automatic. I did not put anything in the Population Schedule…
Sean Chase
  • 1,139
  • 1
  • 15
  • 23
3
votes
1 answer

mysql full text wildcard search like regex

Upto now I have been using WHERE col REGEXP 'IN (.*) WE TRUST' But ever since adding the full index search to this column then this query is very slow. I'm waning to know know how I could implement a wildcard search using full text index…
TheMan68
  • 1,429
  • 6
  • 26
  • 48
3
votes
1 answer

UWP-App created files not indexed in Windows 10 1803

In my UWP App I am creating files that should be indexed by the Windows-index so they can be found later using full-text search. public async Task TestFullTextSearch() { StorageFolder folder = ApplicationData.Current.LocalCacheFolder; …
Rummy
  • 41
  • 4
3
votes
1 answer

Mongodb index built failed

I have a MongoDB with around 80k documents, each one is an entry with title, body_text, etc. I want to do FullTextSearch, for which reason I created a text index with the…
Miguel
  • 2,738
  • 3
  • 35
  • 51
1 2 3
…
37 38