Jump to content

Archived

This topic is now archived and is closed to further replies.

stualk

Select from table where type = NOT 'something'

Recommended Posts

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

Share this post


Link to post
Share on other sites
[code]
SELECT * FROM table WHERE column != 'something'
[/code]

is that all you're after?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.