Steven Rostorfer Steven Rostorfer - 1 year ago 74
SQL Question

Query db with in exlusion

Trying to query db. I need to show all fields, but need to exclude one name that is in the db.


The db contains column

when I try to query it I don't want marketer
but all the others. I have tried tried where clause with all the names and not working.

Answer Source

This is the query you're looking for

SELECT * FROM <table_name> WHERE marketer<>'Tommy';
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download