Full Text Search

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  February 1, 2013 at 1:12 pm

  #269748

  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,

• Ivan Mohapatra

  SSCarpal Tunnel

  Points: 4452

  More actions

  February 11, 2013 at 5:50 am

  #1586498

  Dude try like in the where condition

• suresh0534

  SSCommitted

  Points: 1966

  More actions

  February 11, 2013 at 12:47 pm

  #1586718

  Hi Ivan Mohapatra,

  I tried in Where Condition It self..

  Thanks,