Query on where and like %

[akkerend]

With
SELECT prefix_id
FROM test
WHERE INSTR('077696666444',prefix,1) > 0
you get the prefix_ids of possible prefixes for the number.

How do you know 07769 is the correct prefix, and not 077?