MySQL 8.0

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

CREATE TABLE test (id INT, ticket_id VARCHAR(255));
INSERT INTO test VALUES 
(1,56412), 
(2,'.56412'), 
(3,'-56412'),
(4,' 56412 '),
(5,'X56412');

Records: 5  Duplicates: 0  Warnings: 0


SELECT * FROM test WHERE ticket_id=56412;


id
ticket_id


1
56412

4
 56412


SELECT * FROM test WHERE ticket_id like '%56412';


id
ticket_id


1
56412

2
.56412

3
-56412

5
X56412