MySQL Learning 4 Data filtering

And and OR operators

Cases

Select Prod_name, Prod_price

Form Products

where vend_id =1002 or vend_id=1003 and Prod_price >=10; #这样会先处理 and part of the content, and then process or the content

Example 2

Select Prod_name, Prod_price

Form Products

Where (vend_id =1002 or vend_id=1003) and Prod_price >=10;

In operator

Select Prod_name, Prod_price

Form Products

where vend_id in (1002,1003) #会与括号中的值逐个匹配, the actual effect is the same as where vend_id = 1002 or vend_id=1003

Order BY Prod_name;

Not operator

The NOT operator is the negation of any subsequent condition

Select Prod_name, Prod_price

Form Products

where vend_id not in (1002,1003)

Order BY Prod_name;

MySQL Learning 4 Data filtering