not like in mysql

use not like in mysql query to check if not condition

to check if not condition in mysql query, use "not like" keywords as,

mysql> select category from table where category not like 'Animal'

this query will execute the list of categories added in database except the category 'Animal'