searching the fields

Results 1 to 2 of 2

Thread: searching the fields

  1. #1
    Join Date
    Dec 1969

    Default searching the fields

    i want to make a search in my site ...this search will take the word from the user and go to search about it inside a field in my table...i'm using MS sql server...i need the solution for this search and the sql statement...plz i need help...thanks

  2. #2
    Join Date
    Dec 1969

    Default RE: searching the fields

    You can use the &#039;LIKE&#039; command in SQL. For example, if the user enters the work &#039;bird&#039; into the search, the the sql statement would look like: SELECT * FROM table WHERE myfield LIKE &#039;%bird%&#039;.<BR>The &#039;%&#039; is a wildcard character, which takes the place of missing letters or strings. <BR><BR>I hope this helps.

Posting Permissions

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