-- MySQL 比较运算符
-- = 不等号(<> 或 !=) > < <=>
-- between, in, is null, like, 正则表达式regexp
-- true对应1,flase对应0
select 1=2;
-- 有null参与,返回null
select null=2;
select null <=> 1;
select null <=> null;
-- 字符比较不区分大小写
select 'jike' = 'JIKE';
-- 字符比较区分大小写
select binary'jike' = 'JIKE';
-- 字母按照字母表中的顺序比较
select "j" > "K";
-- between b在ac之间
select 'b' between 'a' and 'c';
select not 'b' between 'a' and 'c';
-- in 5在集合中
select 5 in (1,2,3,4,5);
-- like 模糊匹配 扫描整个表,效率低
select 'jike' like '%ji%';
select 'jike' like '__ke%';
-- = 不等号(<> 或 !=) > < <=>
-- between, in, is null, like, 正则表达式regexp
-- true对应1,flase对应0
select 1=2;
-- 有null参与,返回null
select null=2;
select null <=> 1;
select null <=> null;
-- 字符比较不区分大小写
select 'jike' = 'JIKE';
-- 字符比较区分大小写
select binary'jike' = 'JIKE';
-- 字母按照字母表中的顺序比较
select "j" > "K";
-- between b在ac之间
select 'b' between 'a' and 'c';
select not 'b' between 'a' and 'c';
-- in 5在集合中
select 5 in (1,2,3,4,5);
-- like 模糊匹配 扫描整个表,效率低
select 'jike' like '%ji%';
select 'jike' like '__ke%';