Searching multiple keywords

Results 1 to 2 of 2

Thread: Searching multiple keywords

  1. #1
    Join Date
    Dec 1969

    Default Searching multiple keywords

    I have a database with a field "keywords" which contains a list of keywords separated by commas.<BR>I have to search this field based on a text input.<BR>If the input has only a keyword, it is simple (SELECT ... WHERE keywords LIKE &#039% input %&#039...) but what if the user types more than one keyword? I have to split at the spaces and create the SQL command based on the array of input words...<BR>Have you got the code to do this? <BR>Thanks, Mat

  2. #2
    Join Date
    Dec 1969

    Default RE: Searching multiple keywords

    Check out "Implementing a Search Engine in ASP" at this site

Posting Permissions

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