I have a db in which i have 3 fields i.e:
RangePrefix, StartRange, EndRange
Example data in db:
"", 0A, 9Z
Now if someone searches for 8A or 9A what will be the query to display that ?
SELECT RangePrefix FROM sometable WHERE StartRange <= ? AND EndRange >= ?
This topic is now closed. New replies are no longer allowed.