Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
1 answer

MySQL Fulltext MATCH/AGAINST showing not always results

I have the following table setup: CREATE TABLE IF NOT EXISTS `search_table` ( `fulltext_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID', `data_index` longtext COMMENT 'Data index', PRIMARY KEY (`fulltext_id`), FULLTEXT KEY…
tester
  • 3,977
  • 5
  • 39
  • 59
0
votes
1 answer

Sql Server 2008 "Contains" search searching for numeric value returns all records with a different number of the same length?

I have a search where users can enter any value, sometimes these are legitimately just numeric. When searching for Select * FROM Updates WHERE contains(Remarks, '"10010234331"') it will return unrelated results that have numbers in of the same…
Stormtreader
  • 1
  • 1
0
votes
1 answer

MariaDB Fulltext Search, does not support searches of substrings?

According to the Documentation https://mariadb.com/kb/en/library/fulltext-index-overview/ excluded results are partial words. Does it mean when we search for 'rown' in the phrase 'My cat is brown' with the following SQL Query SELECT…
klgr
  • 191
  • 1
  • 1
  • 12
0
votes
0 answers

How to convert ilike to full text search in Postgres 9.1+

Shopping cart uses following query for searching products: select ... from toode,yksus7,artliik,artryhm where toode.nimetus ilike '%'||{{5}}||'%' escape '!' or toode.toode ilike '%'||{{5}}||'%' escape '!' or toode.analoog ilike…
Andrus
  • 26,339
  • 60
  • 204
  • 378
0
votes
1 answer

How do I structure Solr cores for multiple locales and content types?

I'm looking to run a Solr server to unify search across several different aspects of a public website. First of all, there are several locales (US, Ireland, Japan, etc.) and several types of content (Forums, Regular web pages, Help pages, Products,…
danieltalsky
  • 7,752
  • 5
  • 39
  • 60
0
votes
2 answers

SQL Server Full text search Contains function

İ have a problem with contains function, when i search with like '%ZAM%' operator, it finds all word that contains ZAM like ZAMANLAMA AZAMI ZAM and etc.. but when I use fts index contains function, it just find ZAM ZAMANLAMA but it doesnt find AZAMI…
Mehmet
  • 1
  • 1
  • 1
0
votes
0 answers

Laravel Scout TNTSearch driver does not import all the data

I'm trying to implement search functionality through Laravel Scout using the TNTSearch driver. Overall functionality is working but import does not index all the records in the table. For example, my table has 21 records but it just indexes around 5…
Sanjay Sharma
  • 151
  • 1
  • 6
0
votes
1 answer

Solr pdf index bad request

I'd like to have a simple setup of solr where I can index and search large folders of pdf/docx files. I mostly need just full text search, no need to have fields separated and the original documents do not seem to have well defined structure anyway.…
kakk11
  • 898
  • 8
  • 21
0
votes
1 answer

I am not able to use indexing on Django model field which contains large amount of text. I am using MySQL. What should I do?

First I was using models.TextField, but it doesn't support indexing. Switching to models.CharField didn't help as text size was greater than 50000 characters in some rows. Indexing is allowed for maximum 3072 bytes data in MySQL. Should I switch to…
Utkarsh Garg
  • 125
  • 1
  • 2
  • 12
0
votes
1 answer

Is it possible to implement a token filter chain in elastic search with an UNDO step?

I need a token filter chain for these filter rules: * Remove all stopwords * If the token list is now empty, then restore the stop words Reason: I have to find, for example, the book "It" by Steven King. Any guidance help very much appreciated.
M. Woelfel
  • 3
  • 2
0
votes
2 answers

How to find most relevant strings in a textfile?

I have a text file, which has multiple lines with details of an object. I want to find the score of every string and want to check which string is more relevant to the user input. E.g. the text file contains This is not a blue car Blue or black…
Syed Ali Jaffar Xaidi
  • 11
  • 2
0
votes
1 answer

Computed column as a fulltext index with formatted datetime

I have the following table: [dbo].[TableName] ( [created] datetime not null, [modified] datetime null, [computedValue] as ( format([created], 'yyy-MM-dd MM/dd/yyy') + case when ([modified] is not null) then …
Lubudubu1010
  • 189
  • 4
  • 15
0
votes
1 answer

indexing server in google chrome browser extension

Is it possible to start an indexing server (like SOLR) within a google chrome extension, so that the user can index files to the local server via the extension?
krautgortna
  • 46
  • 5
0
votes
1 answer

Missing Full Text Index System View In Sql Server 2008

I've been reading about the system view: sys.dm_fts_index_keywords_by_document on msdn but can't find the view in my 2008 database. Anyone know if it should be there by default?
Andy
  • 7,646
  • 8
  • 46
  • 69
0
votes
2 answers

How can I solve turkish letter issue in elasticsearch by using C# nest?

In Turkey, we have Turkish letters like 'ğ', 'ü', 'ş', 'ı', 'ö', 'ç'. But when we search generally we use the letters 'g', 'u', 's', 'i', 'o', 'c'. This is not a rule but we generally do it, think like a habit, something we used to. Forexample if i…
loki
  • 2,926
  • 8
  • 62
  • 115
1 2 3
…
37 38