Oracle: SELECT from Table WHERE VALUE NOT LIKE…

logo-oracle-256x256

If you want to select all Values from a Table in your Database and you want to exclude some values, you can try the following Statement:

SELECT TICKET_ID 
FROM TICKET_TABLE
WHERE QUEUE_ID = 4711
AND TICKET_TITLE NOT LIKE 'Printers'
ORDER BY TICKET_ID;