1.b) LIKE clause in SQL

Example:

SELECT name, title, dept FROM employee WHERE title LIKE 'Pro%';




The above statement will select all of the rows/values in the name, title, and dept columns from the employee table whose title starts with 'Pro'. This may return job titles including Programmer or Pro-wrestler.