SitePoint Sponsor |
|
User Tag List
Results 1 to 3 of 3
-
Oct 7, 2009, 20:30 #1
- Join Date
- Feb 2005
- Posts
- 153
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
How to search for several different values in a "Field"?
How would I search for say
2
3
4
5
6
in a field?
I tried comma seperating them but that didnt work. Im used to using the search function in phpmyadmin but have never needed to search for multiple things before.
Perhaps Id have to do a "query"?
-
Oct 7, 2009, 21:23 #2
- Join Date
- Jul 2002
- Location
- Toronto, Canada
- Posts
- 39,347
- Mentioned
- 63 Post(s)
- Tagged
- 3 Thread(s)
Code:SELECT something FROM sometable WHERE somecolumn IN ( 2,3,4,5,6 )
-
Oct 8, 2009, 02:14 #3
- Join Date
- Feb 2005
- Posts
- 153
- Mentioned
- 0 Post(s)
- Tagged
- 0 Thread(s)
Awesome, thanks worked fine.
Bookmarks