Wednesday, February 13, 2013

[MYSQL] 指定比對數個項目 "IN"


判斷欄位值是否等於指定的數個項目其中之一

SELECT * FROM mytable WHERE name IN ('Bill','Candy','Ellen')

No comments:

Post a Comment