mysqlのgroup_concatメソッドと正規(REGEXP)の組み合わせ使用
1042 ワード
詳細
+-------+-------------------------------------+
| names | receive_mobiles |
+-------+-------------------------------------+
| NULL | 13825722737,13375006095,13875005239 |
+-------+-------------------------------------+
1 row in set
+----------------------+-------------------------------------+
| names | receive_mobiles |
+----------------------+-------------------------------------+
|張金民、宋里露、王 華|1382572273133750060951387505239|
+----------------------+-------------------------------------+
1 row in set
select (select group_concat(a.name) from addressbook a where a.mobile in (s.receive_mobiles)) names,s.receive_mobiles from sms_send_record s where id=77;
+-------+-------------------------------------+
| names | receive_mobiles |
+-------+-------------------------------------+
| NULL | 13825722737,13375006095,13875005239 |
+-------+-------------------------------------+
1 row in set
select (select group_concat(a.name) from addressbook a where a.mobile REGEXP replace(s.receive_mobiles,',','|')) names,s.receive_mobiles from sms_send_record s where id=77;
+----------------------+-------------------------------------+
| names | receive_mobiles |
+----------------------+-------------------------------------+
|張金民、宋里露、王 華|1382572273133750060951387505239|
+----------------------+-------------------------------------+
1 row in set