How to search in text column?

• adonetok

  SSCrazy Eights

  Points: 8395

  More actions

  January 9, 2013 at 7:19 am

  #269084

  When I use "Search Customer Reviews" in Amazon.com, it surprises me that it only take less than half second with more than 6000 review. (e.g. review in Kindle Fire HD).

  Which way to make it possible?

• Ant-Green

  SSC Guru

  Points: 113509

  More actions

  January 9, 2013 at 7:24 am

  #1575244

  Unsure what DB platform Amazon run off, but for SQL you could look at Full Text Indexing.

• Sean Lange

  SSC Guru

  Points: 286590

  More actions

  January 9, 2013 at 7:26 am

  #1575245

  6k rows is not really not that much to look through. Full Text indexing can make that sort of thing happen pretty fast.

  --EDIT--

  Seems that Anthony was quicker on the draw here. 😛

  _______________________________________________________________

  Need help? Help us help you.

  Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

  Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.

  Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
  Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
  Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
  Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/