[Resolved] Exclude results from returning

[zzz]

Say I run a query and get results. Can I exclude some based on a certain parameter set in db?

... gee it's getting too basic... need more coffee...

[thorpe]

yes

[zzz]

Great, good news. Since I still haven't had my coffee, could you give me a tip how?

[Drakla]

What type of thing you trying to filter on?

SELECT * FROM table WHERE id NOT IN (3,5,33,16,333,75,4,1,213);

SELECT * FROM table WHERE id > 500;

SELECT * FROM tabke WHERE name NOT LIKE 'scrotty%';

[zzz]

Thanks. Contender #3 is the winner.