Not like is an operator of MySQL. It is used for pattern matching. It compares the column by the given value and returns the list of items which are not like the pattern.
select name from table_name where column_name not like 'pattern';
Database:
Insert:
Table:
Query: