clear markdown feedback
clear markdown feedback
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 3364508 fiddles created (36304 in the last week).

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


SELECT * FROM test WHERE ticket_id=56412;
id ticket_id
1 56412
4 56412
 hidden batch(es)


SELECT * FROM test WHERE ticket_id like '%56412';
id ticket_id
1 56412
2 .56412
3 -56412
5 X56412
 hidden batch(es)