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 |