Need help building SQL query

[Anon]

Hi, I want to select all records where two or more keywords match the contents of either of two columns. The following two queries do not work properly but may provide a better idea of what I am trying to accomplish ...

SELECT * from sites WHERE sitename OR keywords LIKE '%football%' OR '%baseball%';

SELECT * from sites WHERE sitename LIKE '%football%' OR '%baseball%' OR keywords LIKE '%football%' OR '%baseball%';

Any ideas?

[Anon]

I guess I figured it out although it does not look as efficient as I would have imagined. If anyone knows of a shorter way to do this please post. Thanks!

SELECT * from sites WHERE sitename LIKE '%football%' OR sitename LIKE '%baseball%' OR keywords LIKE '%football%' OR keywords LIKE '%baseball%';