[Day 20] SQL in / between / like

下面为 users资料表

in / between / like 都与 SQL where 连用，进阶的搜寻语法。

• in

in:取出指定的资料，各条件之间以分号区隔。

SELECT * FROM users WHERE age in(18,10,32);
SELECT * FROM users WHERE name in('Iris','Amy');

not in:和in判断相反，取得所有非指定条件的资料。

SELECT * FROM users WHERE name not in('Iris','Amy');

• between

between:取出特定范围内连续资料

SELECT * FROM users WHERE age between 10 and 30;

not between:和between判断相反，取得此范围外的所有资料

SELECT * FROM users WHERE age not between 10 and 30;

• like

like:取得引号(' ')内相符的资料，%代表筛选时可以是任意值

SELECT * FROM users WHERE name like 'Jo%';

not like:和like判断相反，取得所有不相符的资料

SELECT * FROM users WHERE name not like 'Jo%';