问题:我需要的是name有可能是bbb,title有可能是'bbb'但是classname要是aaa的结果集
但是下面的写法得不到结果
select * from table 1 a,table2 b where a.id=b.id
and b.classname='aaa' or a.name like 'bbb' or a.title like 'bbbb' 这样的结果是错误的 需要怎么改
但是下面的写法得不到结果
select * from table 1 a,table2 b where a.id=b.id
and b.classname='aaa' or a.name like 'bbb' or a.title like 'bbbb' 这样的结果是错误的 需要怎么改
and b.classname='aaa' and (a.name like 'bbb' or a.title like 'bbbb')
and b.classname='aaa' or a.name like 'bbb%' or a.title like 'bbbb%'
and b.classname='aaa' and (a.name like '%bbb%' or a.title like '%bbbb%')
and b.classname='aaa' AND (a.name like 'bbb%' or a.title like 'bbbb%')
and b.classname='aaa' and (a.name like 'bbb' or a.title like 'bbbb%')
select * from table 1 a,table2 b where a.id=b.id
and b.classname='aaa' and (a.name like '%bbb%' or a.title like '%bbbb%')