mysql匹配表中字符串开头的字符串

I realise that it would be a lot easier if I could modify the table when it was created, but assuming I can't, I have a table that is such as:I realise that it would be a lot easier if I co