Keyword Search

Results 1 to 4 of 4

Thread: Keyword Search

  1. #1
    Wim Hufkens Guest

    Default Keyword Search

    How can I search for a keyword in a database table?<BR>F.e. search for "IT" in a list of book titles?<BR>This ... WHERE Title=&#039"& KeyWord & "&#039... gives only an exact match!<BR>Thanks

  2. #2
    Mr Swifty Guest

    Default RE: Keyword Search

    Like this:<BR>...WHERE Title LIKE &#039***" & Keyword & "***&#039...

  3. #3
    Join Date
    Dec 1969

    Default RE: Keyword Search

    I assume you are using sql server 7.0. You will have to use wildcards like %,[] for getting an exact match or related matches.. <BR><BR> For eg in your case you are searching for a keyword IT in book titles table.<BR><BR>You &#039ll have to use <BR><BR>select * from book_titles where title like &#039%" & keyword & "%&#039<BR><BR>hth<BR>

  4. #4
    Mr Swifty Guest

    Default RE: Keyword Search

    Aha! My previous answer was wrong (which also explains why my own query hasn&#039t been working). As pointed out in the previous reply, use %, not *.<BR>So my answer should have been:<BR>...WHERE FieldName = &#039%%%" & Keyword & "%%%&#039...

Posting Permissions

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