mysql - 我想在第三个括号 [] 内获取字符串

Question

我有一个像

这样的字符串

"Email Request processed successfully Emails:[xyz.abc@qubee.com.bd][HostName 
 =WSRC-AFFILIATE-1, Host Address = 192.168.103.105]" 

如何在mysql中获取“xyz.abc@qubee.com.bd”

Answer 1

如果模式相同，您可以执行以下操作

mysql> select 
 substring_index(
     substring_index('"Email Request processed successfully Emails:[xyz.abc@qubee.com.bd][HostName = WSRC-AFFILIATE-1, Host Address = 192.168.103.105]"',
    'Emails:[',-1
     ),
']',1) as s ;


+----------------------+
| s                    |
+----------------------+
| xyz.abc@qubee.com.bd |
+----------------------+