long postal code in db prevents searching by zipcode range

A long bogus zip code in database such as 1234567891011121314151617181920 breaks search by zip code range.

MySQL cannot cast such a large number as an integer; the database error is [nativecode=1292 ** Truncated incorrect INTEGER value: '1234567891011121314151617181920']

The query REGEXP could be tweaked to limit the search to a certain length of e.g. 10 digits or whatever is appropriate.