mysql IN operator
Translation results：
英[ɪn] 美[ɪn]
prep. Adopt (a certain way); wear, carry; (indicates position) in..., (indicates domain, range) within...; ( Indicates quality, ability, etc.) in...
adv. At home; enter, arrive; popular; elected
adj. Including, inward; in office, in power; [Colloquial] Popular, fashionable; (car, etc.) arriving at the station
n. The ruling party, the person in power; the insider; <Meikou> entrance, access; <body> (board ball or baseball) the team attacking the ball
plural: ins
mysql IN operatorsyntax
Function: Specify multiple values in the WHERE clause.
Syntax: SELECT column_name(s) FROM table_name WHERE column_name IN (value1,value2,...)
mysql IN operatorexample
//从上表中选取姓氏为 Adams 和 Carter 的人
SELECT * FROM Persons WHERE LastName IN ('Adams','Carter');