Mysql选择哪里 [英] Mysql select where

问题描述

Mysql select where value 90 and 45 but not 90 with type 1 here is my sample table

Mysql select where value 90 and 45 but not 90 with type 1 here is my sample table

value   |   type    |   status
90          1           0
90          1           1
90          0           0
90          0           1
45          1           0
45          1           1

我的代码没有得到想要的输出

My code didn't get the desired output

SELECT * FROM table WHERE type IN (1, 0) AND value != 90

所需的输出是:

value   |   type    |   status
90          0           0
90          0           1
45          1           0
45          1           1

推荐答案

您正在查看一个相当基本的复合条件 - 您想要all type=0"或all type=1 except when value=90"，即表示为

You're looking at a fairly basic compound condition - you want "all type=0" or "all type=1 except when value=90", which would be expressed as

WHERE (type = 0) OR (type = 1 AND value != 90)

(基于您自己的查询)，或

(based on your own query), or

WHERE (value = 45) OR (VALUE = 90 AND type != 1)

(基于你的第一句话.)

(based on your first sentence.)

这篇关于Mysql选择哪里的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！