MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();


version()


8.0.27


CREATE TABLE product (
PRODUCT_ID VARCHAR(255));

INSERT INTO product VALUES
('33009900000000'),
('33019900000000'),
('33029900000000'),
('33039900000000'),
('33559900000000'),
('33899900000000'),
('33999900000000'),
('33032200000000'),
('33552200000000'),
('338g2200000000');
SET @modelid := 99;

SELECT *,
        CONCAT('33%',@modelid,'00000000')
FROM product where PRODUCT_ID LIKE CONCAT('33%',@modelid,'00000000')


PRODUCT_ID
CONCAT('33%',@modelid,'00000000')


33009900000000
33%9900000000

33019900000000
33%9900000000

33029900000000
33%9900000000

33039900000000
33%9900000000

33559900000000
33%9900000000

33899900000000
33%9900000000

33999900000000
33%9900000000

PRODUCT_ID	CONCAT('33%',@modelid,'00000000')
33009900000000	33%9900000000
33019900000000	33%9900000000
33029900000000	33%9900000000
33039900000000	33%9900000000
33559900000000	33%9900000000
33899900000000	33%9900000000
33999900000000	33%9900000000