SELECT * FROM IC7400 WHERE de LIKE '%collector%' OR '%open%';
All it's returning is whatever the first term is, ignoring the term after the OR statement.
I verified this by switching the location of the terms and getting a different number of results. With collector first, I get 79 results, with open first I get 89 results.
Is there a reason because after looking through many forums, it doesn't seem like anyone else is really having this issue, and I can't find a good explanation on how to use only the OR statement properly.
I don't know what they did, but Google has really taken a hit on it's ability to return relevant search results. It used to be so good. Now it's getting to be as bad as those other ones that never return what I need.