xProteuSx Posted July 3, 2012 Share Posted July 3, 2012 Is there a way to do this using mysql? SELECT * WHERE year < 2000 AND year > 1900 for example? Quote Link to comment https://forums.phpfreaks.com/topic/265138-select-within-numeric-range/ Share on other sites More sharing options...
kicken Posted July 3, 2012 Share Posted July 3, 2012 Yes, the condition you posted as your example is valid: WHERE field > minimum AND num < maximum You could also use the BETWEEN operator to do a range search. WHERE field BETWEEN minimum AND maximum Quote Link to comment https://forums.phpfreaks.com/topic/265138-select-within-numeric-range/#findComment-1358750 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.