search question

Results 1 to 2 of 2

Thread: search question

  1. #1
    Join Date
    Dec 1969

    Default search question

    hello,<BR><BR>is the only way to search through records the "like &#039;%blahblah%&#039;" ?<BR><BR>how do search engines like altavista work?<BR><BR>split the string on spaces and build a <BR><BR>where x like &#039;%word1%&#039; or x like &#039;%word2%&#039;<BR><BR>with it?<BR><BR>or is there a special search command whatever to do this?

  2. #2
    Join Date
    Dec 1969

    Default Full Text Indexing

    Different databases support what&#039;s called full text indexing.<BR><BR>It&#039;s much more efficient to use it instead of doing just what you said (splitting the word and doing multiple LIKEs).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts