Skip to main content

Operator

AND OR NOT​

  • AND：只有滿足所有條件才會出現
  • OR：只要滿足任一條件就會出現
  • NOT：只會出現不滿足條件的
SELECT * FROM book WHERE bookname like '%java%' AND price<1000;
SELECT * FROM book WHERE bookname like '%java%' OR price<1000;
SELECT * FROM book WHERE NOT price >1000;

BETWEEN​

  • Between：在兩個值之間才會顯示
SELECT * FROM book WHERE price BETWEEN 1000 AND 2000;

IN NOT IN​

  • IN：在多個值其一才會顯示
  • NOT IN：不在多個值的才會顯示
SELECT * FROM publisher WHERE contact IN ('paul','mary','james');
SELECT * FROM publisher WHERE contact NOT IN ('paul','mary','james');