Stack Overflow
Stack Overflow

Questions tagged [fulltext-index]

123 questions
2
votes
0 answers

How to query rows using Full Text Index that contains '&' in SQL Server?

I have a table with Full-Text indexing enabled on it and the table has some rows which contains strings such as following: 'HON & HAN' Now I want to fetch this row using a query that uses full text indexing. Here is what I am trying (but it is…
Farooq Hanif
  • 1,779
  • 1
  • 15
  • 22
2
votes
1 answer

MySQL: Best way to search in files' content (fulltext search)

I'm currently developing a website which allows the users to upload presentations, documents and e-books (something like scribd and slideshare) so I need to be able to search in the file's content. I'm currently extracting the text from the files in…
stormbreaker
  • 848
  • 13
  • 22
2
votes
1 answer

deploy a dacpac that contains a fulltext index with msdeploy

How to deploy a dacpac that contains a FULLTEXT INDEX (built from a database project) to SQL Server using msdeploy? MSdeploy skips creation of the fulltext indexes, and fails when creating objects that depend on the (now missing) fulltext…
user1692392
  • 21
  • 3
2
votes
1 answer

MySQL Fulltext Search Error Only On Some Queries

when I use fulltext search in my MySQL 5.6 MyISAM table I sometimes get an error but most of the time it works fine. This query works fine SELECT title, MATCH(title, keywords, description) AGAINST ('background+water+sea') AS 'relevance' FROM…
Peter K
  • 21
  • 2
2
votes
2 answers

Full Text Search SQL can't find digital value in nvarchar field

I have a Stored Procedure, which uses full-text search for my nvarchar fields. And I'm stuck when I realized, that Full-Text Search can't find field if I type only numeric values of this field. For example, I have field Name in my table with value…
Sevastsyan Oseev
  • 27
  • 5
2
votes
1 answer

MySQL FULLTEXT cant find index

I try to run the following query SELECT * FROM complains WHERE match(title, description) against('+lorem' IN BOOLEAN MODE) Table complains has two FULLTEXT indexes. title and description but I still get this error from MySQL Error Code: 1191. Can't…
Raggaer
  • 3,244
  • 8
  • 36
  • 67
2
votes
2 answers

FULLTEXT index on one column vs multiple columns in following scenario?

I have this table structure and I am using MYSQL post` ( `post_id_pk` INT, `title` VARCHAR(100), `description` TEXT, `search_content` TEXT ) I have a search functionality. IF an user type a text into textbox and if that word contains in…
Prageeth Liyanage
  • 1,612
  • 2
  • 19
  • 41
2
votes
1 answer

Using Full-Text indexing to crawl binary blobs

If i store binary files (e.g. doc, html, xml, xps, docx, pdf) inside a varbinary(max) column in SQL Server, how can i use Full-Text indexing to crawl the binary files? Imagine i create a table to store binary files: CREATE TABLE Documents ( …
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
2
votes
1 answer

MySQL: Split longtext column into multiple text columns

I have a slight challenge with data that I need to get solved. I have a table where the plain text of emails is stored in a longtext column. It was like this before I started developing in the framework. There are over a million rows already with…
Kobus Beets
  • 29
  • 5
2
votes
0 answers

SQL Server 2005 Alter Full text catalog not populating indexes

Hi I am rebuilding a full text catalog as follows: ALTER FULLTEXT CATALOG myCatalog REBUILD It is not populating my indexes. When i use the FULLTEXTCATALOGPROPERTY to check the properties I am getting the populating status always as 0 and the…
Kalyan
  • 43
  • 2
2
votes
0 answers

Azure SQL Search. Full-text search. Optimise select statement

I got a table with around 20 millions of rows. The database is hosted on Azure. (S2 tier) I set up full-text index on one of the columns (the column contains Counties, States, Cities, Towns, Townships, Villages, Schools, Colleges and so on). Here…
Stanislav
  • 165
  • 1
  • 15
2
votes
2 answers

Search queries in neo4j: how to sort results in neo4j in START query with internal TFIDF / levenshtein or other algorithms?

I am working on a model using wikipedia topics' names for my experiments in full-text index. I set up and index on 'topic' (legacy), and do a full text search for : 'united states': start n=node:topic('name:(united states)') return n The first…
user305883
  • 1,635
  • 2
  • 24
  • 48
1
vote
0 answers

SQL CONTAINSTABLE does not return all the expected results

I have a table with just 2 columns Id (identity) and lastname(nvarchar). I applied a fulltextIndex WITH ACCENT_SENSITIVITY = OFF for dutch --> 1043 on lastname with an empty stop words list and added 2 records: insert into [UserProfile] values …
DM1983
  • 33
  • 3
1
vote
1 answer

Mysql FULLTEXT MATCH score is zero, in boolean mode, even though both terms are present

I have a table squirrel_schools that has a FULLTEXT index on the keywords field (among others). I'm doing a BOOLEAN search against two of the words in keywords and getting a score of zero, which doesn't make sense: SELECT record_id, keywords, (MATCH…
Max Williams
  • 32,435
  • 31
  • 130
  • 197
1
vote
2 answers

MySQL using MATCH AGAINST for long unique values (8.0.27)

I have a situation where we're storing long unique IDs (up to 200 characters) that are single TEXT entries in our database. The problem is we're using a FULLTEXT index for speed purposes and it works great for the smaller GUID style entries. The…
Floobinator
  • 388
  • 2
  • 11
1
2
3
…
8 9