Select based on one field being different values

[nathj]

Hi,

I have developed a table for storing navigation items, this is then used to built the navigation panel on my website.

Each item has a field indicating which bar it is to go on:
0 = Every bar,
1 = Top level page only
2 = Child page 1 only
3 = Child Page 2 only
99 = All child pages

So If iwas building up the navigation panel for child page 2 I need to get all items where the bar is set as 0 or 3 or 99.

I have experience writing software in Visual FoxPro which had a built in function called inlist(field, value1, value2, ...). I know this was built in function and it basically worked as
id = 0 or id = 3 or id = 99.

My question is this. Is there something similar in mySQL or do I simply need to build the list with the'or' in it?

Many thanks
nathj

[r035198x]

Hi,

I have developed a table for storing navigation items, this is then used to built the navigation panel on my website.

Each item has a field indicating which bar it is to go on:
0 = Every bar,
1 = Top level page only
2 = Child page 1 only
3 = Child Page 2 only
99 = All child pages

So If iwas building up the navigation panel for child page 2 I need to get all items where the bar is set as 0 or 3 or 99.

I have experience writing software in Visual FoxPro which had a built in function called inlist(field, value1, value2, ...). I know this was built in function and it basically worked as
id = 0 or id = 3 or id = 99.

My question is this. Is there something similar in mySQL or do I simply need to build the list with the'or' in it?

Many thanks
nathj

In does that nicely

select ... where field in (0, 3, 99);

[nathj]

In does that nicely

select ... where field in (0, 3, 99);

Perfect. That's exactly what I wanted. I have only ever used in for subqueries before and so it didn't even cross my mind.

Thank you for your help, it not only performs better it makes my query easier to build!

Cheers
nathj

[r035198x]

Perfect. That's exactly what I wanted. I have only ever used in for subqueries before and so it didn't even cross my mind.

Thank you for your help, it not only performs better it makes my query easier to build!

Cheers
nathj

* blush *