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

BlackBerry 5.0 Control for free-text search

I'm developing a BlackBerry 5.0 app. I have an entity to be displayed on screen in a grid format. Entity: Employee Fields: EmpId(int), FirstName(string), LastName(string), Hobby(string) Once I display the list of entites (which I know how to do), I…
Pavan Kulkarni
  • 476
  • 5
  • 17
0
votes
1 answer

Optimizing an SQL search using a column for keywords and a variable as the text to be searched

Here's my quandary. I have a variable that contains a paragraph of text, and I have a column full of keywords. I want to search each of the keywords contained in the column against the entirety of the text contained within my variable. The only way…
Joshua
  • 107
  • 1
  • 4
  • 12
0
votes
0 answers

SQL Server : Freetext search with And Operator

Project table Name columns contains this data: USA Russia England Canada Canada Query: SELECT name FROM project WHERE FREETEXT(name, '"USA Canada"') Result: the query returns both rows. Expectation: the query should only return 1 row containing…
hsn
  • 31
  • 4
0
votes
1 answer

How to split a dataframe row into several rows if they're above a certain word count?

I have a dataframe that is made up of two columns. One column has a numbered value, and the next column is free text. One entry has a prodigious number of words (2k +), and that is making it hard to create a table of that data frame in a .pdf file…
Alokin
  • 461
  • 1
  • 4
  • 22
0
votes
1 answer

SQL Server FREETEXT search not returning any results

For some reason, I do not get a result on the SQL Server Freetext search term with the following code. Both tables are fulltext indexed (in a catalog), and the query somehow works, but as mentioned, I don't get a result as wished... SELECT [Col8],…
Bernhard Sailer
  • 1
  • 3
0
votes
0 answers

when i write MS SQL full text search query for return all matches, then it give me not correct output

this is my query:- select * from dbo.zones where freetext(name, 'test'); select * from dbo.zones where contains(name, 'formsof(INFLECTIONAL, test)'); this give me result of- test, testing, tested Select * from dbo.zones where contains(name,…
Ranveer
  • 11
  • 4
0
votes
1 answer

Using SQL to Return Entire Paragraph if a word is found

I would like to return all the words surrounding the search term in a varbinary text enabled column. For example, if the word crisis is found, I would like to return the paragraph or at least 10 words on each side of the searched word. I am able to…
David Olsen
  • 19
  • 3
0
votes
1 answer

Why we need FREETEXT if we already have CONTAINS?

Why we need FREETEXT if we already have CONTAINS? in SQL Server can you you give where exactly we can make use of. Syntax for using FREETEXT is exactly the same as CONTAINS , so When you need to do an CONTAINS and FREETEXT,
Ramakrishna.p
  • 1,159
  • 12
  • 31
0
votes
1 answer

SQL Server FullTextSearch FREETEXT does not return expected results

I have the following sql server query SELECT * FROM [dbo].Client WHERE FullName LIKE '%Lind%' Which returns the following row: When I run the following Full Text Search query that row is not returned SELECT * FROM [dbo].Client WHERE…
pantonis
  • 5,601
  • 12
  • 58
  • 115
0
votes
1 answer

Email ID filter using freetext sql server

I cannot able to filter email from table using 'freetext' in sql server. For ex: select * from abc where column = 'abc@gsd.com' is getting all data having @ and .com think so.
Balajisriram S
  • 1
0
votes
1 answer

Fulltext index in MySQL for mediumtext field?

Is it at all possible to add a working fulltext index on a mediumtext field in oracle? I have been able to make an index, but I do not get any results when I query it. It might be that my sql is flawed: (ps. I am absolutely sure that the 'someText'…
Automatico
  • 12,420
  • 9
  • 82
  • 110
0
votes
1 answer

Apply HTML filter to FREETEXT SQL Query on nvarchar(max) column

So I'm converting an existing system to support Freetext search and I've a tiny issue. The column CONTENT is type of nvarchar(max) and stores HTML, which means cases like

foo

Will not work because the HTML Filter won't be applied. So…
VoidEssy
  • 23
  • 7
0
votes
2 answers

Using SQL CONTAINS with multiple words inside a variable

I'm trying to use SQL CONTAINS function with variables. Usually, I can use CONTAINS the following way: WHERE CONTAINS(tablename, '"some text to search for"') However, I can't figure out how to insert a variable inside that function that would…
Robbie Dee
  • 39
  • 2
  • 7
0
votes
0 answers

What is the use of "\+" keyword while performing freetext in sql-server?

One of our senior developers uses "+" while performing a freetext search. I am not able to understand the use of it. I have tried to remove the condition where he used "+" keyword but here was no change in result. declare @SearchText varchar(100) =…
AVINASH KUMAR
  • 1
  • 2
0
votes
1 answer

Syntax error near ',' in the full-text search condition ','

This is my stored procedure. When I pass "," in @BusinessName I am getting error: Syntax error near ',' in the full-text search condition ','. How do I resolve this error? ALTER PROCEDURE [dbo].[SearchBusiness] @uid bigint, @BusinessName…
Happy Singh
  • 95
  • 2
  • 9
1 2 3 4
5
6 7 8