Using WHERE to Filter Character Data
You can use the WHERE clause to filter character data by searching for a text string.
For example, this statement is processed by searching the employee table for every row that satisfies the condition: the job_title column contains the character string “analyst”. The name and dept_no fields for those rows are then listed.
SELECT name, dept_no
FROM employee
WHERE UPPER (job_title) LIKE '%ANALYST%';