SQL string match numbers, varying length

Answer 1

I would think something like

WHERE ? LIKE concat(leadin, '%') order by length(leadin) desc limit 1

(I haven't checked the function names, and I'm not certain that this will work in MYSQL - I'm pretty sure it will work in one of the SQL's I've used).