一点小注意的地方

mysql> select goods_name,shop_price from goods where cat_id=3 and(shop_price<100
 or shop_price>5000) and click_count>5;
+----------------+------------+
| goods_name     | shop_price |
+----------------+------------+
| 多普达Touch HD      |    5999.00 |
+----------------+------------+
1 row in set (0.00 sec)

mysql> select goods_name,shop_price from goods where cat_id=3 and (shop_price in
(4000,6000)) and click_count>5;
Empty set (0.00 sec)