我有一个emails
的列表,我想写一个where语句,以排除包含邮箱域%@icloud.com
或%@mac.com
的only行
例如,
emails
个列表如下所示:
abc@gmail.com; 123@hotmail.com
123@outlook.com; abc@icloud.com
123@icloud.com;
123@icloud.com; abc@mac.com
所需的输出应如下所示:
abc@gmail.com; 123@hotmail.com
123@outlook.com; abc@icloud.com(this row should be returned because it also contains '@outlook.com' which isn't on my exclude list)