Close...
SELECT * WHERE E contains 'CBO' OR F contains 'CBO'
Always check your spaces in your queries, they are important.