Sql query with where conditions

I have table ‘zipcode’ and that have column ‘code’. Code column have staring of zipcode like

I want to write sql query from that i can identify is this zip code match with records?

Valid Input zipcode