mysql> SELECT * FROM tbl_Test1 JOIN tbl_Test2 ON tbl_Test1.Phone LIKE CONCAT(tbl_Test2.PhoneLike,'%');
+------+--------+------+----------+-----------+
| ID   | Phone  | ID   | Vorname  | PhoneLike |
+------+--------+------+----------+-----------+
|    1 | 123456 |    1 | Teutales | 1234      |
+------+--------+------+----------+-----------+
1 row in set (0.00 sec)