Questions tagged [fulltext-index]
123 questions
0
votes
0 answers
Fulltext column mysql dont find 'client' in word 'clients'
I have a varchar column that contains the word clients. It is fulltext with clients data. I am failing to locate the row when searching by word client. I am hoping to avoid LIKE because of number of records. Is LIKE the only way to go? I read that…
user7366786
- 11
- 2
0
votes
1 answer
What is Error SQL71578 related to Full-text Index in Microsoft Azure SQL Database v12?
When I try to compile a database project in Visual Studio targeting Microsoft Azure SQL Database v12, on the following command
CREATE FULLTEXT INDEX ON [dbo].[MyTable]
([Col01] LANGUAGE 1033 STATISTICAL_SEMANTICS
, [Col02] LANGUAGE…
Tohid
- 6,175
- 7
- 51
- 80
0
votes
1 answer
Fulltext index search has large number of page reads
I have a full-text index on a column in a table that contains data like this:
searchColumn
90210 Brooks Diana Miami FL diana.brooks@email.com 5612233395
The column is an aggregate of Zip, last name, first name, city, state, e-mail and phone…
Radu Gheorghiu
- 20,049
- 16
- 72
- 107
0
votes
0 answers
Partial Match in Full Text search in SQL Server 2014 failed
I have implemented full text search in SQL Server 2014. I need partial match implementation in full text search in SQL Server 2014.
When I type 'erik grant', the results are given below
When I type 'ran', I am expecting all the names containing…
MUHAMMAD TASADDUQ ALI
- 387
- 2
- 14
0
votes
0 answers
MongoDB text search add language
Is it possible to add a language to the existing languages that MongoDB supports? Like defining custom stop words? I would like to use text search with the Slovenian language.
Blaž Štempelj
- 13
- 1
- 5
0
votes
0 answers
Mariadb match against a view fails; succeeds in MySql
The fulltext search query below fails in mariadb, but succeeds in mysql (mariadb database imported from mysql database using phpmyadmin).
If a base table is substituted, the query succeeds in both mariadb and mysql. So apparently mariadb cannot…
HenrikBechmann
- 579
- 2
- 5
- 19
0
votes
1 answer
MySQL Fulltext index search returns wrong results
I have a MyISAM table with a Fulltext index on the NAME column which is VARCHAR(200). I'm searching the table using the Boolean mode and I'm getting very strange results. Example: Let's look for records with the word "TRULY" in the NAME column:…
navidoo
- 309
- 2
- 11
0
votes
0 answers
Why match against mysql innodb works only with one argument
I have a problem with the MATCH(...) AGAINST(...) functions in MySQL.
I saw some examples of MATCH(...) AGAINST(...) but when I try them they are not working and shows an error:
#1191 - Can't find FULLTEXT index matching the column list .
I have…
farzad
- 612
- 8
- 24
0
votes
1 answer
SQL Server: One large persisted computed column for Fulltext Indexing
It appears to me as the easiest, most straightforward solution, but please correct me if I'm wrong.
Instead of having a fulltext index on all individual columns of a table, isn't it better to just generate one single wide computed column and run the…
Alex
- 75,813
- 86
- 255
- 348
0
votes
1 answer
Neo4j\Lucene multiterm wildcard at the end of query
I'm trying to create auto suggestion based on Lucene full text index.
The main issue is how to create autosuggestion(autocomplete) based on multiterm phrases, for example -
nosql dat*
results can be
nosql database
nosql data
but not
perfect nosql…
alexanoid
- 24,051
- 54
- 210
- 410
0
votes
1 answer
full-text index creation says column already indexed
The following SQL statement creates an error:
Create FullText Index "X_D_FTI"
On "XING_DESC"("DESCRIPTION")
TEXT ANALYSIS ON
CONFIGURATION 'EXTRACTION_CORE';
This is the error output
Could not execute 'Create FullText Index "X_D_FTI" On…
Thorsten Niehues
- 13,712
- 22
- 78
- 113
0
votes
1 answer
MySQL full text query across multiple columns
I have an issue that I'm confused about when using a full text search in MySQL. I'm running MySQL 5.1.67. Here is my simplified table:
CREATE TABLE `contact_info` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`first_name` varchar(25) DEFAULT…
dbCarl
- 127
- 1
- 7
0
votes
1 answer
Issue with Match Against in search query
I have a situation with a website who lists products.
I'm using a fulltext index with a Match Against search
There is a field named "itemcode" that field is in varchar type
turns out one of the codes for instance, goes like
"WTC-153-U"
And when i…
DJ22T
- 1,628
- 3
- 34
- 66
0
votes
1 answer
How to use CONTAINS with inline queries in SQL Server 2008?
I have this sql query where I'm trying to use CONTAINS to search the title field.
But I get this error.
"Cannot use a CONTAINS or FREETEXT predicate on column 'Title' because it is not full-text indexed."
The Titles table has been indexed and a…
Donny V.
- 22,248
- 13
- 65
- 79
