Hi,

I am all messed up putting an appropriate case statement into my 'where' clause but no correct results obtained yet, is there any way to do the following?

Can anyone tell me the code for:-

SELECT `column1`,`column2`,`column3`,`column4`, `column5`,`column6` ,`column7` FROM `tablename` WHERE `column7`NOT IN
CASE `column2`
WHEN '1' THEN ( 'abcd','efgh','ijkl','mnop')
WHEN '2' THEN ' '
END
and `column6`>='0' order by `column2`,`column6`

Thanks in advance

Id suggest a sub select query