Exact Word Search Using Full text Property

Question

1.00/5 (1 vote)

See more:

i have a table which contain 50000 rows, and i want to search some specific text in One column..

i use Like % %, Method and it give me result in avg 3 min,'

So i use Full text search and it work well

but now My Problem is Full text Search not support Exact Word Search...

so what can i do in this situation..

I Just want that my Query give Result before Server Time Out...

please Help

Posted 18-Jun-14 2:28am

Arun kumar Gauttam

Add a Solution

Comments

Sergey Alexandrovich Kryukov 18-Jun-14 13:18pm

Not clear. This post won't make any sense unless you create and show some code samples or otherwise provide sufficient detail on what you are trying to do.
—SA

2 solutions

Solution 2

Yes right, if you could provide some code snippet that would help us to understand your problem better.

But what I understand from your code is, you are trying to find a specific word or phrase in a column, if that is the objective, you could do that using CONTAINS key ward as below;

SQL

SELECT Comments
FROM ProductReview
WHERE CONTAINS(Comments, '"learning curve"')

The above SQL will return all the rows where Comments column has the specific phrase "learning curve", provided there is a full text index for the ProductReview table.

You could get more detail in MSDN site;
http://msdn.microsoft.com/en-us/library/ms142583.aspx

Posted 18-Jun-14 8:53am

anup.bhunia

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

anup.bhunia · Accepted Answer · 2014-06-18T08:49:00

Yes right, if you could provide some code snippet that would help us to understand your problem better.

But what I understand from your question is, you are trying to find a specific word or phrase in a column, if that is the objective, you could do that using CONTAINS key ward as below;

SQL

SELECT Comments
FROM ProductReview
WHERE CONTAINS(Comments, '"learning curve"')