Select with pattern from table in sqlite

Hi i have table with column contain this values

patern_number
0936
09154
123456

and i have number which can be anything
what i want is a select which return 1 when input number start with one of pattern else return 0
example
input number -------result
093628987 ----- ----- 1
0915 --------------------0
0222---------------------0
091546666-------------1
so can anyone help me?