我有一个像
"Email Request processed successfully Emails:[[email protected]][HostName
=WSRC-AFFILIATE-1, Host Address = 192.168.103.105]"
我怎样才能进入"[email protected]"MySQL
如果模式相同，则可以执行以下操作：
mysql> select
substring_index(
substring_index('"Email Request processed successfully Emails:[[email protected]][HostName = WSRC-AFFILIATE-1, Host Address = 192.168.103.105]"',
'Emails:[',-1
),
']',1) as s ;
+----------------------+
| s |
+----------------------+
| [email protected] |
+----------------------+
本文收集自互联网，转载请注明来源。
如有侵权，请联系 [email protected] 删除。
我来说两句