By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select version();
| version() |
|---|
| 8.0.23 |
create table users (id int);
insert into users (id) values (0), (1), (2);
set @id = '1AW3F4SEFR';
SELECT * FROM users WHERE id = @id AND @id REGEXP '^[0-9]+$';
set @id = '1';
SELECT * FROM users WHERE id = @id AND @id REGEXP '^[0-9]+$';
| id |
|---|
| 1 |