How to the numbers which start by a number given in a database?

[Hany dawa]

Example:
1235
23985
23444

number given is 23
results:2

[johny10151981]

if the field is number then

the query should be

SELECT COUNT(*) from desired_table where (desired_field/100)=constant_number

this query is only for first 2 bytes

if it is string

SELECT COUNT(*) from desired_table where desired_field like '%constant_number'