mysql查询中的条件与匹配
select * from user where password like '%1' and id=2-- SELECT * FROM user WHERE password LIKE '%1' AND id=2语句意思为查询user表中所有列里满足条件password结尾为1并且id等于二的数据其中where子句和like子句有蛮多可操作空间,where是在sql中指定条件的子句,可以使用and或or指定一个或多个条件select * from user where id=1 and sta