SQL Query + Array?

[furious5]

I've got a script which is building its SQL on the fly which I'm having a few problems with, any help would be appreciated.

My first problem is that I am wanting to search a field however with a number of different values.

What is the SQL for this, I must be having a no brainer moment?

E.g I want to search for jobs in industries - accounting, aviation, it

[trooper]

you need to use 'OR' in you sql query

e.g

SELECT * from table where sector ='engineering' OR sector='aviation'

hth

gm

[kevinc]

Yes, you're going to use the "OR" clause in mySQL, however, be careful you aren't left with a query that resembles something like this :

$query = "SELECT * from jobs where sector='IT' OR sector='Accounts' OR";

In that case, it's an invalid query. Just do some checking for unused clauses.

For your information, you can alternatively use || instead of OR.

[Weedpacket]

If there are a lot of possibilities and sector='this' OR sector='that' OR sector='the other' OR ... gets too long, then you can have sector in ('this', 'that', 'the other', ...) instead. It may also be faster.