且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

SQL Where子句具有多个值

更新时间:2021-07-10 03:23:52

只需使用IN子句

where number in (123, 127, 130)

您还可以使用OR(仅用于提供信息,在这种情况下,我不会使用此功能)

you could also use OR (just for info, I wouldn't use this in that case)

where number = 123 or
      number = 127 or
      number = 130

如果where子句中有其他条件,请不要忘记在或"周围加上圆括号.

Don't forget round braces around the "ors" if you have other conditions in your where clause.