- '<=' - smaller than or equal with
- '>=' - bigger than or equal with
- 'LIKE' - if you want to search for a pattern within a string or want to compare a string with a pattern, than create a pattern and search for all the elements which are 'like' the pattern.
1. you can use the '%' symbol to search for a string out of more than one character - ex. 'like %factory' will filter all the strings which end in the word 'factory'
2. you can use the '_' symbol to search for a single character - ex. 'like product_' will filter all the strings which begin with the word 'product'
- 'NOT LIKE' - this operator works the opposite way of 'LIKE'
- 'IS NULL' - it has no value
- 'IS NOT NULL' - it has a value
- 'IN' - searches for a chosen data within a filter