开发者

DBVisualizer query snytax to add a range of values

开发者 https://www.devze.com 2023-02-08 09:47 出处:网络
I need to be able to do something like this in DBVisualizer: WHERE Column = {12, 23, 55, 33, 22} Instead, I am doing this

I need to be able to do something like this in DBVisualizer:

WHERE Column = {12, 23, 55, 33, 22}

Instead, I am doing this

WHERE Col开发者_开发知识库umn = 12 OR Column = 23 OR Column = 55 OR Column = 33 OR Column = 22

Is there some sort of syntax reserved for this purpose? The latter is very tedious, and I am not a database person. So any help is very much appreciated!


WHERE Column in (12,23,55,33,22)

note that this language is not a function of dbvisualizer, but of the database you are connecting to. The above code works for every RDBMS I've ever worked with. http://www.w3schools.com/sql/sql_in.asp

I think this wants the SQL tag!

0

精彩评论

暂无评论...
验证码 换一张
取 消