Advanced search for sql

Results 1 to 2 of 2

Thread: Advanced search for sql

  1. #1
    Join Date
    Dec 1969

    Default Advanced search for sql

    I want to built an advanced search engine for my site, that is to say an engine that will search through my database keywords using "the whole phrase", "all the words" or "any word" options for the text string entered by the user. I have inserted in the form a menu form object and assigned a value to be sent to the server for each option selected but I don't know what to do next. How do I process these values ? Should I write a script at the search page or the results page ? maybe write an sql script after each option value in the form ? I would very much appreciate any help......

  2. #2
    Join Date
    Dec 1969

    Default RE: Advanced search for sql

    If you&#039;re using SQL Server, have you looked at full-text searching? That can help in terms of performance if you have a lot of text and/or text fields to search through.<BR><BR>

Posting Permissions

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