Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Full Text Search Expand / Collapse
Author
Message
Posted Friday, February 1, 2013 1:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 1:54 PM
Points: 46, Visits: 252

I have one table in sql server say example
Table Name: candidates

Test table contains some columns

cid , cname,c_resume these are the columns
cid in Int ,cname is nvarchar(50), c_resume is text Data Type.

I am Storing candidates resume in c_resume text filed.

I have 10000 rows in table.

If i search c++ resume it will showing the result of c++ and also it showing the resume other than c++

if i search c++11 also it giving the results.

if i search c++1 it not showing any results(Zero Results).

I have written Query like this:

select * from candidates WHERE contains(c_resume_text,'C++') -It shwoing c++ and also other than c++ results.

select * from candidates WHERE contains(c_resume_text,'C++11') -It showing results.

select * from candidates WHERE contains(c_resume_text,'C++1') -It showing Zero results.

Why the above 2 and 3rd showing different results?

in c_resume_text filed there is no word c++11 , but we have c++ word.

I am not understanding the above results? why ?what is happening?


Please help me,

How can i sove the problem,

Thanks,
Post #1414832
Posted Monday, February 11, 2013 5:50 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:21 AM
Points: 123, Visits: 446
Dude try like in the where condition
Post #1418358
Posted Monday, February 11, 2013 12:47 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 1:54 PM
Points: 46, Visits: 252
Hi Ivan Mohapatra,

I tried in Where Condition It self..

Thanks,
Post #1418608
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse