在MySQL中，如何指定WHERE-IN子句的排序规则？

Question

SELECT * FROM myTable WHERE email_address = 'foo@bar.com' COLLATE utf8_general_ci;

但是，如果WHERE-IN子句中有多个电子邮件地址，则以下代码将失败

SELECT * FROM myTable WHERE email_address IN ('foo@bar.com', 'test@test.com') COLLATE utf8_general_ci;

为了让它正常工作，我错过了什么？Mysql 5.5。

谢谢!

Answer 1

如果在每个字符串后面指定它会怎么样：

WHERE email_address IN ('foo@bar.com' COLLATE utf8_general_ci, 'test@test.com' COLLATE utf8_general_ci)

Answer 2

尝尝这个

SELECT * 
FROM myTable 
WHERE FIND_IN_SET( email_address, 'foo@bar.com,test@test.com' COLLATE utf8_general_ci );