Please give SQL statement for develop keyword search like google

• anup_phansa

  SSC Enthusiast

  Points: 102

  More actions

  September 8, 2009 at 12:12 am

  #75518

  I want to create a search on Address field of xyzTable

  If my searching string is “A B C D”

  XyzTable

  ID

  1, A B C D

  2, A B

  3, A B C

  4, 1 A

  6, 2 C

  7, FF

  8, KK

  Search Result

  Out put Record

  1, A B C D

  2, A B

  3, A B C

  4, 1 A

  6, 2 C

  The record which maximum match display first

  I want to develop key word search like google

  Regards

  Anup

• ps.

  One Orange Chip

  Points: 29422

  More actions

  September 8, 2009 at 12:14 am

  #1050314

  Look out for Full Text Search on books online.

  ---

  
  Pradeep Singh

• Sergiy

  SSC Guru

  Points: 110208

  More actions

  September 8, 2009 at 12:17 am

  #1050315

  http://labs.google.com/papers/bigtable.html

  _____________
  Code for TallyGenerator