Selecting from the range of serial numbers

--0016e646055ade1d97046f76e97f
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Hi

My stock serial number format is 00001A - 99999A, 00001B - 99999B ... 00001Z
- 99999Z.

These stocks are check in to warehouse in different order, so the worker may
check in the stocks like

00001A - 00100A
99999B - 00010C
00051B - 00070B


I have a table to keep track the stock check in transaction:


STOCK_CHECKIN

start_sequence int(10) unsigned
start_batch char(1)
end_sequence int(10) unsigned
end_batch char(1)


and the data for the above example will look like this:

start_sequence start_batch end_sequence end_batch
00001 A 00100 A
99999 B 00010 C
00051 B 00070 B


I couldn't figure out how to determine if a specific serial number is
already checked in into the warehouse.
Based on the above data, the serial number 00010A, 00001C and 00070B are
already checked in.

How would be the effective SQL looks like?


Thank you!


--

Hez

--0016e646055ade1d97046f76e97f--

RE: Selecting from the range of serial numbers

V0hFUkUgNzAgQkVUV0VFTiBzdGFydF9zZXF1ZW5jZSBBTkQgZW5kX3NlcXVl bmNlDQogQU5EICdD
JyBCRVRXRUVOIHN0YXJ0X2JhdGNoIEFORCBlbmRfYmF0Y2g7DQoNClRob3Vn aCB3aGF0IHlvdSBz
aG91bGQgcmVhbGx5IGRvIGlzIGFkZCBhIHVuaXF1ZSBhdXRvIGluY3JlbWVu dCB0byBldmVyeSBz
eW1ib2wsIHRoZW4geW91IG9ubHkgaGF2ZSB0byBkbyBhIHNpbXBsZSByYW5n ZSBjaGVjay4NCg0K
T3IgdXNlIGEgZnVsbCByZWxhdGlvbmFsIHN0cnVjdHVyZSBhbmQgaGF2ZSBh IE9UTSBvciBNVE0g
d2l0aCB5b3VyIHN0b2NrIHRhYmxlLg0KDQpSZWdhcmRzLA0KR2F2aW4gVG93 ZXkNCg0KLS0tLS1P
cmlnaW5hbCBNZXNzYWdlLS0tLS0NCkZyb206IGhlemppbmcgW21haWx0bzpo ZXpqaW5nQGdtYWls
LmNvbV0NClNlbnQ6IEZyaWRheSwgSnVseSAyNCwgMjAwOSAxMDoyNyBBTQ0K VG86IG15c3FsQGxp
c3RzLm15c3FsLmNvbQ0KU3ViamVjdDogU2VsZWN0aW5nIGZyb20gdGhlIHJh bmdlIG9mIHNlcmlh
bCBudW1iZXJzDQoNCkhpDQoNCk15IHN0b2NrIHNlcmlhbCBudW1iZXIgZm9y bWF0IGlzIDAwMDAx
QSAtIDk5OTk5QSwgMDAwMDFCIC0gOTk5OTlCIC4uLiAwMDAwMVoNCi0gOTk5 OTlaLg0KDQpUaGVz
ZSBzdG9ja3MgYXJlIGNoZWNrIGluIHRvIHdhcmVob3VzZSBpbiBkaWZmZXJl bnQgb3JkZXIsIHNv
IHRoZSB3b3JrZXIgbWF5DQpjaGVjayBpbiB0aGUgc3RvY2tzIGxpa2UNCg0K MDAwMDFBIC0gMDAx
MDBBDQo5OTk5OUIgLSAwMDAxMEMNCjAwMDUxQiAtIDAwMDcwQg0KDQoNCkkg aGF2ZSBhIHRhYmxl
IHRvIGtlZXAgdHJhY2sgdGhlIHN0b2NrIGNoZWNrIGluIHRyYW5zYWN0aW9u Og0KDQoNClNUT0NL
X0NIRUNLSU4NCg0Kc3RhcnRfc2VxdWVuY2UgaW50KDEwKSB1bnNpZ25lZA0K c3RhcnRfYmF0Y2gg
Y2hhcigxKQ0KZW5kX3NlcXVlbmNlIGludCgxMCkgdW5zaWduZWQNCmVuZF9i YXRjaCBjaGFyKDEp
DQoNCg0KYW5kIHRoZSBkYXRhIGZvciB0aGUgYWJvdmUgZXhhbXBsZSB3aWxs IGxvb2sgbGlrZSB0
aGlzOg0KDQpzdGFydF9zZXF1ZW5jZSBzdGFydF9iYXRjaCBlbmRfc2VxdWVu Y2UgZW5kX2JhdGNo
DQowMDAwMSBBICAwMDEwMCBBDQo5OTk5OSBCICAwMDAxMCBDDQowMDA1MSBC ICAwMDA3MCBCDQoN
Cg0KSSBjb3VsZG4ndCBmaWd1cmUgb3V0IGhvdyB0byBkZXRlcm1pbmUgaWYg YSBzcGVjaWZpYyBz
ZXJpYWwgbnVtYmVyIGlzDQphbHJlYWR5IGNoZWNrZWQgaW4gaW50byB0aGUg d2FyZWhvdXNlLg0K
QmFzZWQgb24gdGhlIGFib3ZlIGRhdGEsIHRoZSBzZXJpYWwgbnVtYmVyIDAw MDEwQSwgMDAwMDFD
IGFuZCAwMDA3MEIgYXJlDQphbHJlYWR5IGNoZWNrZWQgaW4uDQoNCkhvdyB3 b3VsZCBiZSB0aGUg
ZWZmZWN0aXZlIFNRTCBsb29rcyBsaWtlPw0KDQoNClRoYW5rIHlvdSENCg0K DQotLQ0KDQpIZXoN
Cg0KVGhlIGluZm9ybWF0aW9uIGNvbnRhaW5lZCBpbiB0aGlzIHRyYW5zbWlz c2lvbiBtYXkgY29u
dGFpbiBwcml2aWxlZ2VkIGFuZCBjb25maWRlbnRpYWwgaW5mb3JtYXRpb24u IEl0IGlzIGludGVu
ZGVkIG9ubHkgZm9yIHRoZSB1c2Ugb2YgdGhlIHBlcnNvbihzKSBuYW1lZCBh Ym92ZS4gSWYgeW91
IGFyZSBub3QgdGhlIGludGVuZGVkIHJlY2lwaWVudCwgeW91IGFyZSBoZXJl Ynkgbm90aWZpZWQg
dGhhdCBhbnkgcmV2aWV3LCBkaXNzZW1pbmF0aW9uLCBkaXN0cmlidXRpb24g b3IgZHVwbGljYXRp
b24gb2YgdGhpcyBjb21tdW5pY2F0aW9uIGlzIHN0cmljdGx5IHByb2hpYml0 ZWQuIElmIHlvdSBh
cmUgbm90IHRoZSBpbnRlbmRlZCByZWNpcGllbnQsIHBsZWFzZSBjb250YWN0 IHRoZSBzZW5kZXIg
YnkgcmVwbHkgZW1haWwgYW5kIGRlc3Ryb3kgYWxsIGNvcGllcyBvZiB0aGUg b3JpZ2luYWwgbWVz
c2FnZS4NCg==