By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE items (
name VARCHAR(50),
variable VARCHAR(50));
INSERT INTO items VALUES
('123456789','12345'),
('12345678','12345'),
('12345679','12345'),
('1234569','12345'),
('12349','12344'),
('12344123','12344'),
('12346','12344'),
('12233','12233'),
('1223311','12233');
Records: 9 Duplicates: 0 Warnings: 0
SELECT * FROM items WHERE LEFT(name,5)=LEFT(variable,5);
SELECT * FROM items WHERE name LIKE CONCAT(LEFT(variable,5),'%');
SELECT * FROM items WHERE name LIKE CONCAT('%',LEFT(variable,5));
SELECT * FROM items WHERE name LIKE CONCAT('%',LEFT(variable,5),'%');
| name | variable |
|---|---|
| 123456789 | 12345 |
| 12345678 | 12345 |
| 12345679 | 12345 |
| 1234569 | 12345 |
| 12344123 | 12344 |
| 12233 | 12233 |
| 1223311 | 12233 |
| name | variable |
|---|---|
| 123456789 | 12345 |
| 12345678 | 12345 |
| 12345679 | 12345 |
| 1234569 | 12345 |
| 12344123 | 12344 |
| 12233 | 12233 |
| 1223311 | 12233 |
| name | variable |
|---|---|
| 12233 | 12233 |
| name | variable |
|---|---|
| 123456789 | 12345 |
| 12345678 | 12345 |
| 12345679 | 12345 |
| 1234569 | 12345 |
| 12344123 | 12344 |
| 12233 | 12233 |
| 1223311 | 12233 |