By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.30 |
CREATE TABLE tester (
barcode varchar(255)
);
INSERT INTO tester(barcode)
VALUES ('HYD123'), ('HYD0123'), ('HYD4231');
Records: 3 Duplicates: 0 Warnings: 0
SELECT cast(barcode AS UNSIGNED)
FROM tester;
| cast(barcode AS UNSIGNED) |
|---|
| 0 |
| 0 |
| 0 |
SELECT CAST(TRIM(LEADING 'HYD' FROM barcode) AS UNSIGNED)
FROM tester;
| CAST(TRIM(LEADING 'HYD' FROM barcode) AS UNSIGNED) |
|---|
| 123 |
| 123 |
| 4231 |
SELECT barcode
FROM tester
WHERE CAST(TRIM(LEADING 'HYD' FROM barcode) AS UNSIGNED) BETWEEN 120 AND 4232;
| barcode |
|---|
| HYD123 |
| HYD0123 |
| HYD4231 |
SELECT CAST(SUBSTR(barcode, 4) AS UNSIGNED)
FROM tester;
| CAST(SUBSTR(barcode, 4) AS UNSIGNED) |
|---|
| 123 |
| 123 |
| 4231 |
SELECT barcode
FROM tester
WHERE CAST(SUBSTR(barcode, 4) AS UNSIGNED) BETWEEN 120 AND 4232;
| barcode |
|---|
| HYD123 |
| HYD0123 |
| HYD4231 |