MySQL 8.0

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