SitePoint Sponsor

User Tag List

Results 1 to 4 of 4

Thread: wildcard

  1. #1
    SitePoint Guru
    Join Date
    Apr 2001
    Location
    BC, Canada
    Posts
    630
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    wildcard

    Is there a value that I can be put into the where clause that would act like a wild card? kinda like

    where collum='*wildcardthing*'

  2. #2
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Location
    Ann Arbor, MI
    Posts
    33
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Well, I think using

    SELECT * FROM table
    WHERE column = *
    ....

    would work, but then it's basically a useless line; it doesn't _do_ anything. (And therefore I'm not sure it would actually work).

    LL

  3. #3
    SitePoint Enthusiast
    Join Date
    Jul 2001
    Location
    Texas
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    yeah, you don't need to use a WHERE for that, the simple SELECT * FROM table will work
    Mark -
    www.magicscripts.net

  4. #4
    SitePoint Guru
    Join Date
    Apr 2001
    Location
    BC, Canada
    Posts
    630
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    well heres the story
    i have an advanced search with 3 drop down menus.. each drop down searches a particular collum... each drop down box has a default value to select all
    The long way to do it is to build a query string depending on if each box had a particular value selected

    easy way is out to have the default value in the drop downs * or whatever the wildchar is, that way I dont have to build a query everytime, I can just use the same one each time

    get what I mean?


Bookmarks

Posting Permissions

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