[Resolved] MySQL SELECT statement

Is it possible to do a SELECT statement along the lines of:

$selfund = "'101' or '132' or '310'";
SELECT * FROM projects WHERE fund_type LIKE ($selfund)

Under nomal circumstances I would do WHERE id = 1 or id = 2 etc but the length of the selection criteria can change (e.g. '3' or '4' or '5' or '6').

I've tried selecting the values individually and that's fine but when I combine them the returned data are all id='1'.

Thanks.
Mark.

$selfund = "'101', '132', '310'";
SELECT * FROM projects WHERE fund_type IN($selfund)

that should work for ya 😉

just the IN clause should be in the format of

'x', 'x2', 'x3'

Brilliant - works perfectly.
Why didn't anyone tell me about 'IN'? Doh!

Mark.

Originally posted by mpainter
Brilliant - works perfectly.
Why didn't anyone tell me about 'IN'? Doh!

Mark.

didn't I? 😕 :p