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? 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 Link to comment https://forums.phpfreaks.com/topic/265138-select-within-numeric-range/#findComment-1358750 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.