Stack Overflow
Stack Overflow

Questions tagged [freetext]

FREETEXT is an SQL text-search predicate that uses stemming (e.g. -ing, -ly) and a thesaurus to search for the given string.

FREETEXT is a predicate used to search columns containing character-based data types for values that match the MEANING and not the exact wording of the words in the search condition. When FREETEXT is used, the full-text query engine internally performs the following actions on the freetext_string, assigns each term a weight, and then finds the matches.

109 questions
0
votes
1 answer

Identify free text keyword duplicates with percentage match

There are several name titles in my database that gets created and recreated with minor changes very often. With manual eyeballing one can easily identify them as duplicates with minor spelling changes. For e.g. Resort Inn, Res Ort inn, Rsort Inn…
user676500
  • 33
  • 5
0
votes
1 answer

Does using Hive with HBase render faster response times and good for web applications?

In this video, it was indicated that Hive will render data with slow response times. I would like to know if integrating Hive with HBase would be suitable for web-based live-running applications (CRUD), and secondly, if free-text searching (not…
ElHaix
  • 12,846
  • 27
  • 115
  • 203
0
votes
2 answers

Handling nulls on freetext

I am trying to use FREETEXT. The @name field often has nulls and this is not an error in the program. It just means that other search approaches are being used. Originally I had DECLARE @Name varchar(50) = ... -- some value which many be NULL or…
James A Mohler
  • 11,060
  • 15
  • 46
  • 72
0
votes
2 answers

Full-Text Search Not working (FREETEXT - CONTAINS)

Freetext not return all of the words from table. And Contains not work I have a one row wich include in mycolumn="Life of a King" I tried 2 method; First "contains" SELECT * FROM MYTABLE WHERE CONTAINS(MYCOLUMN,'Life NEAR of NEAR a NEAR King') It…
Pisagor
  • 147
  • 1
  • 2
  • 16
0
votes
1 answer

How to create asp.net dataset freetext query

I have a database with a fulltext catalog setup for one of my tables and the goal is to be able to conduct a freetext search against that table from an asp.net c# website. Using SQL Management Studio, I can manually run the queries such as: SELECT…
bg.dev
  • 68
  • 7
0
votes
1 answer

SQL FREETEXT Search Escaping Space

I have a Thesaurus table in my database, I want to collect data using FREETEXT. However the string I'm searching for contains spaces. For example, I want to search for the code "AB 001" select * from TheThesaurus where freetext(TheDefinition, 'AB…
sora0419
  • 2,308
  • 9
  • 39
  • 58
0
votes
1 answer

SQL Full-Text Search vs. LIKE Search Performance

I've been searching on the internet and found the Full-Text Search usually have a better performance. I followed the instructions on this post to set up thesaurus tables on my machine so I can play around with it and get more familiar with full-text…
sora0419
  • 2,308
  • 9
  • 39
  • 58
0
votes
2 answers

Select every row with contains

I have a function that returns a table based on some filter. One of the filters is a title which can be null The following query is possible when filtering the table: DECLARE @DocumentTitle VARCHAR(150) SET @DocumentTitle = NULL SELECT * FROM…
Nițu Alexandru
  • 714
  • 1
  • 11
  • 33
0
votes
1 answer

pymongo full text search how to return only stats?

I am using free text search of mongo2.4 with pymongo. What I want is to get the number of documents having some text. In the mongo shell, increasing the limit is a good turnaround, but from python it gets very slow since all documents have to be…
colin
  • 81
  • 2
  • 7
0
votes
2 answers

mongodb2.4 elastic search and free text search

I have mongodb with collections having million records of free text. I want to enable online query on this text. I was considering between using : the model data for keyword search…
colin
  • 81
  • 2
  • 7
0
votes
4 answers

What's your solution for free-text search and sort?

AFAIK,MySQL performs really bad at this, what's your solution? BTW,what's the solution of SO? EDIT Please pay attention that free-text search itself is pretty fast in MySQL, but not the case when the result also needs to be sorted on an attribute!
Misier
  • 1,455
  • 4
  • 13
  • 15
0
votes
1 answer

Passing the database columns as parameter in Contains or Freetext

I am trying to pass the searchable columns as parameter to the stored procedure, but it never work contains(@RTitleColumn, @searchTerm) I am passing the @RtitleColumn as the first CONTAINS parameter here is the full query SELECT Lid As ItemID,…
Moe9977
  • 259
  • 5
  • 16
0
votes
1 answer

freetextbox is not loading properly

I have 28 freetexboxes on my ASP.NET 4.5 web form and the 29th freetexbox does not load properly. The 29th freetextbox doesn't have color or border. Can someone tell me how to resolve it?
lokesh
  • 1
0
votes
1 answer

Is it possible to convert HTML to Richtext format?

I have a freetextbox and want to convert it's output to richtext format. for example this is the text of my freetext: loblob how to convert it to Richtext format?
Raymond Morphy
  • 2,464
  • 9
  • 51
  • 93
0
votes
1 answer

Fulltext search (sql server 2005) works only on some fields

OK this is the situation.. I am enabling fulltext search on a table but it only works on some fields.. CREATE FULLTEXT CATALOG [defaultcatalog] CREATE UNIQUE INDEX ui_staticid on static(id) CREATE FULLTEXT INDEX ON static(title_gr LANGUAGE…
Gabriele Petrioli
  • 191,379
  • 34
  • 261
  • 317
1 2 3 4 5 6
7
8