表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);