troubleshooting Question

query where data field is a range

Avatar of iceman19330
iceman19330 asked on
MySQL Server
10 Comments1 Solution402 ViewsLast Modified:
So I have a shipping table with the first three of the zip code, the issue is that certain areas have certain delivery zones.  so the table rather then having each 3 digit code have its own row, its grouped together for certain ranges, and the ranges can be 2-30 between start and finish in the range of zip codes.  for example.  one might be 004-005, while another might be 010-043 and so on and so forth.  is there a way to query for the range, so lets say someone is in a zip code that starts with 032, which would be in the 010-043 range.  is that possible?
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros