Steven Rostorfer Steven Rostorfer - 6 months ago 6
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.

Example:

The db contains column

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

Answer

This is the query you're looking for

SELECT * FROM <table_name> WHERE marketer<>'Tommy';
Comments