mysql regexp结合使用,mysql的group_concat方法和正则(REGEXP)的结合使用

1.正则表达式 Function RegExpTest(patrn,strng)'patrn表示要进行匹配的字符串；strng表示基字符串 Dim regEx,Matches,regString set regEx=New RegExp'简历正则表达式 regEx.Pattern=partn'确定要匹配的字符串 regEx.lgnoreCase=True'不区分大小写 regEx.Glo

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 setselect (select group_concat(a.name) from adfind()和group()

/*正则表达式功能：获取:将字符串中符合规则的子串取出步骤：1，将正则表达式封装成对象2，让正则对象和要操作的字符串关联3，获取正则匹配引擎4， 通过引擎对符合规则的子串进行操作，比如取出*/import java.util.regex.*;class RegexDemo2dressbook a where a.mobile REGEXP replace(s.receive_mobiles,',','|')) names,s.receive_mobiles from sms_send_record s where id=77;+----------------------+-------------------------------------+| names

| receive_mobiles

|+----------------------+-------------------------------------+| 张款民,宋里露,王

华 | 13825722737,13375006095,13875005239 |+----------------------+-------------------------------------+1 row in set