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*'
| SitePoint Sponsor |
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*'
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
yeah, you don't need to use a WHERE for that, the simple SELECT * FROM table will work
Mark -
www.magicscripts.net
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?
Posting Permissions
Bookmarks