mysql - 任何人都可以告诉我我的查询出了什么问题

Question

我想搜索具有特定 ID 的名称。

select * from members where 1=1 AND MemberID IN('2,8') and Status = '1' AND (FirstName LIKE 'v%') ORDER BY MemberID

这是我的查询。谁能告诉我出了什么问题以及用特定 ID 搜索名称的正确查询是什么。

谢谢

Answer 1

You must not use single quotes in IN clause. If your MemberId column is varchar type or character type, you must use MemberID IN('2','8')

but if your MemberID is integer type, you must use: MemberID IN(2,8)