SQL相关

一、=,IN,LIKE的区别

=比较的是单一的值，IN是多个值，LIKE是匹配的模式

select * from wenda.comment;
SELECT * FROM wenda.comment where id=1;
select * from wenda.comment where id in (1,2,3,4);
select * from wenda.comment where id like '%1%';

上面四条执行结果分别是：