stualk Posted September 27, 2006 Share Posted September 27, 2006 Hi Chaps,Does anyone know how to do a select from query where something is NOT 'something'?What i'm trying to do is to display products from a database where the product type is NOT 'something' (i.e. display all product types except 'something')Is this easy to do?Thanks Quote Link to comment Share on other sites More sharing options...
obsidian Posted September 27, 2006 Share Posted September 27, 2006 [code]SELECT * FROM table WHERE column != 'something'[/code]is that all you're after? Quote Link to comment Share on other sites More sharing options...
stualk Posted September 28, 2006 Author Share Posted September 28, 2006 That's exactly what I wanted, works a treat. Didn't realise it was so simple but thanks for that. Useful for the future that.Thanks. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.