How to get double digit items from Mysql database?

Question

MySQL

The task is to compare the variable (id) taken by the GET method from the address bar with the id of the goods in the table and display the id elements with a two-digit number, a three-digit number, etc. from the Mysql database.
How to make such requests?
The goal is to display similar products from the database by id
id of similar products, respectively, have their own identifier (1 group - two-digit, 2 - three-digit, etc.)

Answer 1

select * from tbl where length(id) = 3;

Answer 2

If id is a number, then you can make the condition WHERE id < 10 (1 character), id >= 10 AND id < 100 (2 characters) and so on, for example.