By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE table1 (
barcode varchar(255)
);
INSERT INTO table1 VALUES
('HYD123'),
('HYD1234'),
('HYD132453741 ');
Records: 3 Duplicates: 0 Warnings: 0
select *
from table1;
| barcode |
|---|
| HYD123 |
| HYD1234 |
| HYD132453741 |
SELECT oo.barcode, cast(SUBSTRING_INDEX(oo.barcode,'HYD',-1) AS UNSIGNED INTEGER)
FROM table1 oo
WHERE cast(SUBSTRING_INDEX(oo.barcode,'HYD',-1) AS UNSIGNED INTEGER) between 122 and 1250
| barcode | cast(SUBSTRING_INDEX(oo.barcode,'HYD',-1) AS UNSIGNED INTEGER) |
|---|---|
| HYD123 | 123 |
| HYD1234 | 1234 |