表A字段a包含表B字段a查询

mysql> select * from a1;
+--------+
| id ids|
+--------+
| 201401 123#456#234 |
| 201402 789#123#678 |
| 201403 321#234#789 |
| 201404 789#264#769 |
+--------+


mysql> select * from b1;
+----+
| id |
+----+
| 123 |
| 234 |
| 456 |
+----+

我想把a1.id中含有b1.id的值的记录找出来，这相当于对b1.id的值分别做like查询：
select * from a1 where a1.id like '%123%' UNION select * from a1 where a1.
id like '%234%' UNION select * from a1 where a1.id like '%456%';

最后想要得到下面的效果

+--------+
| id |
+--------+
| 201401 |
| 201402 |
| 201403 |
+--------+

解决方式：
一、
mysql> select * from a1 where exists (select id from b1 where INSTR(a1.id,id));
二、
mysql> select * from a1 where exists (select id from b1 where a1.id like concat(
'%',id,'%'));
三、mysql> select * from a1 where exists (select id from b1 where a1.id regexp id);
四、
mysql> select distinct a1.id
-> from a1 inner join b1 on a1.id regexp b1.id;
五、
mysql> select distinct a1.id
-> from a1 , b1
-> where INSTR(a1.id,b1.id);