Combining logical operators 1

[audiopro]

I have been googling around to find the syntax used when combining logical operators in mysql but to no avail. I have found previews for books, had google tell me numerous times that there is no need to use 'AND' in searches (The search term I used was 'MYSQL combine AND and OR') and have followed numerous links to nowhere.
The good links I have found only deal with single operators or multiples of the same operator.
Can anyone suggest any good reading on the subject.
I have tried the obvious

SELECT * FROM TABLE WHERE (F1='A') AND (F2='B' OR F3='B' OR F4='C')

Thinking the brackets would group the parts together.
I need always to match f1='A' and any one or more of the others.

Keith

http://www.studiosoft.co.uk

 

[audiopro]

Is there a better way to do this than combining large numbers of comparative operators?

Keith

http://www.studiosoft.co.uk

 

[r937]

use parentheses when they are required

ANDs take precedence over ORs, but if you mix them, i would always use parentheses

additional background article: Web Scripting and Logic, or Boolean Algebra

r937.com | rudy.ca

 

[audiopro]

Thanks for that
Just what I needed

Keith

http://www.studiosoft.co.uk