SQL Syntax query

[jonathen]

Hi,

I know this is such a basic question, but for the life of me I cannot recall what I did in the past.

I have a SELECT statement that does:

SELECT * FROM mytable WHERE area = 'area1' OR 'area2'

Now that's fine. However, I only want to display all entries which are listed under area1 & area2, IF the region is region1 or region2.

i.e: SELECT * FROM mytable WHERE area = 'area1' OR 'area2' IF region = 'region1' OR 'region2'

Trouble is, I can't recall the syntax, nor find it on mysql.com, and IF doesn't seem to work, nor does a second WHERE or HAVING.

Can anyone recall the syntax I need for this? It has to be watertight - it must ONLY display those results within those areas IF within those regions.

TIA for any help,

Jonathen

[diego25]

Maybe this?

SELECT * FROM mytable WHERE (area = 'area1' OR area = 'area2') AND (region = 'region1' OR region = 'region2')

Diego

[jonathen]

Ta very much, that's the one! I knew it would be something simple - I had tried using AND on it's own, without putting the statements into () - good thinking.

Thanks again,

Jonathen