问条SQL语句。。。关于查询的
select * from petinformation where pettype like '%ko% ' or petname like '%ko% ' or petage like '%ko% ' and pettypelist= '1 '
怎么不行的呢？？
就是想把查询多个字段里的内容 且 pettypelist字段一定要等于我给的一个值
[解决办法]
select * from petinformation where (pettype like '%ko% ' or petname like '%ko% ' or petage like '%ko% ') and pettypelist= '1 '
