Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
0 answers

Can't find FULLTEXT index matching the column list in MySQL 5.7

I have an issue when executing a query with using MATCH AGAINST. I am using view for combining tables results and then I run a query on that view. The issue is that the query runs just fine in MariaDB 10.1, but the same query throws this error in…
Katerina
  • 99
  • 1
  • 12
0
votes
1 answer

Can SQL Server use a fulltext index for a LIKE query?

I wish to avoid a fullscan for a query using the LIKE keyword: SELECT * FROM MYTABLE WHERE MYCOLUMN LIKE '%WORD%'` AND PRICE < 3; With SQL Server, we can define a fulltext index and use it with the CONTAINS clause (and other ones). The problem:…
Olivier Faucheux
  • 2,520
  • 3
  • 29
  • 37
0
votes
2 answers

Mysql full text returnig NULL

My mysql code. CREATE TABLE `videos` ( `id` int(50) NOT NULL, `user_id` int(250) NOT NULL, `title` varchar(250) NOT NULL, `discription` text NOT NULL, `video_path` varchar(250) NOT NULL, `tumbnail_path` varchar(250) NOT NULL, `paid`…
Arun VM
  • 447
  • 1
  • 6
  • 17
0
votes
0 answers

Full-text Indexing got stuck with error code 3602 and search was not working

Full-text index got stuck and search was not working. Please help me with this issue. It was fixed with a restart of the SQL Server, but i need to know the root cause of this issue. Kindly add your thoughts on it. If you need any more information…
John VM
  • 106
  • 15
0
votes
1 answer

How to optimize inverted file for full text indexing?

I am making a simple program where I am using a sample of PDF files to build a full text indexing on my database. The idea is I read each PDF file, extract the words and store them in a hashset. Then, add each word in a loop to the table in MySQL…
Daredevil
  • 1,672
  • 3
  • 18
  • 47
0
votes
1 answer

wordforms on sphinx

If I use the wordforms file, to a word like this: television > tv If i search for television, i'd get results with TV on it, but i also want to have television results, is that possible?
williamhrs
  • 35
  • 7
0
votes
2 answers

Java - Extracting non duplicate words from PDF files

I wrote a simple program in Java using PDFBox to extract words from a PDF file. It reads the text from PDF and extract word by word. public class Main { public static void main(String[] args) throws Exception { try (PDDocument document…
TomCold
  • 83
  • 6
0
votes
1 answer

How does termFreq function query work in Apache Solr

I am trying to query solr index using its API, http://localhost:8983/solr/documents/select?defType=func&q=termfreq(contents,'hello)&wt=json I have indexed 3 documents and 2 documents/records have the term "hello" but it returns all the documents. { …
Root
  • 955
  • 1
  • 16
  • 39
0
votes
2 answers

Returning all rows of a query where the string values in one column match the string values in another column

I have been searching endlessly for the answer to this problem I have been having: Our team uses a query that returns a dataset with 13 columns. We want to narrow down the results by returning only rows where any string value in column "Actual…
brisenburg
  • 11
  • 3
0
votes
1 answer

Why is my MySQL Full Text search not working?

I'm using MySQL FullText search and It works, but I can't get the following result. Ex: SELECT * FROM countries WHERE MATCH (name) AGAINST ("Chinese*" IN BOOLEAN MODE); It should give me the country record "China", but it doesn't work, any…
Pedro
  • 1,459
  • 6
  • 22
  • 40
0
votes
1 answer

Full text index doesn't work at single word?

I have a full text index on many columns of the customer table, one of which columns is fname. The following query: select * from customer where fname like 'In%' and code='1409584557891' returns me the line needed, this customer has an fname of…
George Menoutis
  • 6,894
  • 3
  • 19
  • 43
0
votes
1 answer

How to view the index contents of a fulltext index in MySQL?

Is it possible to see the actual content of a FULLTEXT INDEX in MySQL? Or even query the index directly (like SELECT words FROM table.fulltext_index and it would return all indexed words, just to have a example)? For a regular b-tree index on a…
Foobar
  • 303
  • 2
  • 8
0
votes
1 answer

MySql FullTextSearch in Boolean mode returning returning results shorter than ft_min_word_len

I am using Mysql FTS query as below in Boolean Mode SELECT org.org_name FROM org WHERE MATCH org.org_name AGAINST ('an*' in BOOLEAN MODE); and this gives me the following result +--------------------------+ | org_name …
HopeKing
  • 3,317
  • 7
  • 39
  • 62
0
votes
1 answer

Difference in data retrieved with full-text index search in SQL Server 2012 and SQL Server 2016

There is an issue with full-text search in SQL Server 2012 while it works fine in SQL Server 2016. I have the following sample images showing the output of the similar query which returns data with underscore in 2016 and in other screen it doesn't…
John VM
  • 106
  • 15
0
votes
2 answers

MySQL FULL TEXT NOT ACCURATE

I have a table with id, topic ,description, image url as columns. Entries like id topic description image_url 1 People and blogs TownHall http://... 2 People and blogs 2 ...... ....... 3 Blogs …
Krishna
  • 65
  • 1
  • 9
1 2 3
…
37 38