mysql - 子字符串返回定界符后的所有值

Question

如何获取第一个分隔符后的所有值？在下面的示例中，我期待 'xyz@yahoo.com,pqr@company.com'

(02:40) mysql>select substring_index('abc@hotmail.com,xyz@yahoo.com,pqr@company.com', ',',  1) as first;
+-----------------+
| first           |
+-----------------+
| abc@hotmail.com |
+-----------------+
1 row in set (0.00 sec)

(02:41) mysql>select substring_index('abc@hotmail.com,xyz@yahoo.com,pqr@company.com', ',',  -1) as last;
+-----------------+
| last            |
+-----------------+
| pqr@company.com |
+-----------------+
1 row in set (0.00 sec)

Answer 1

   select substring('abc@hotmail.com,xyz@yahoo.com,pqr@company.com',
   instr('abc@hotmail.com,xyz@yahoo.com,pqr@company.com', ',') + 1) as first;