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 Link to comment https://forums.phpfreaks.com/topic/22266-select-from-table-where-type-not-something/ 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? Link to comment https://forums.phpfreaks.com/topic/22266-select-from-table-where-type-not-something/#findComment-99698 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. Link to comment https://forums.phpfreaks.com/topic/22266-select-from-table-where-type-not-something/#findComment-100164 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.