hi all
why is it this query returns everything
select * from table where name not like ('%a%') or name not like ('%b%')
not like %a% will include %b% and not like %b% will include %a%
so together your excluding nothing.
so how do we perform the right sql? since there is no such as
select * from table where name not like in ('%a%','%b')
AND not OR
Thanks
I did changes from OR to And yesterday and works perfect
