MySQL search: WHERE multi-Condition
WHERE can be searched by multiple conditions.
The products table is as follows:
After a WHERE, search by and based on two conditions and three conditions: <Strong? Http: www.bkjia.com kf ware vc "target =" _ blank "class =" keylink "> VcD4KPHA + pgltzybzcm9 "http://www.2cto.com/uploadfile/Collfiles/20140712/2014071209025227.png" alt = "\">
B uses or to search for multiple conditions
C. Find out the products with a price greater than 10 produced by vend_id of 1002 or 1003. here we need to use and or for combination:
However, from the above results, this output is not correct because AND has a higher priority than OR. Therefore, this statement is used to retrieve all products with vend_id = 1002, for products with vend_id = 1003 and a price greater than 10, you need to use () to rewrite this sentence:
D. Use IN to show multiple search values. The function is similar to OR. However, when there are multiple values, the syntax for using IN is more intuitive.
The e NOT operator denies the following conditions:
Different systems.