一、=,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%';
上面四条执行结果分别是:
一、=,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%';
上面四条执行结果分别是: