LIKE, WILDCARDS, BETWEEN, IN

LIKE operator is used in a WHERE clause to search for a specific pattern data in a specific column.
Two wildcards used in with the LIKE operator:
% : The percent sign represents zero, one, or multiple characters
_  : The underscore represents a single character
SYNTAX
SELECT column1, column2, column3,...
FROM table_name 
WHERE column_name 
LIKE pattern; 

EXAMPLE
SELECT id, name, mobile_number 
FROM mobile_users
WHERE name;
LIKE '_a%' 

IN operator is used to specify multiple values in a WHERE clause.
SYNTAX
SELECT column1, column2, column3,...
FROM table_name 
WHERE column_name
IN('val1', 'val3', 'val3'); 

EXAMPLE
SELECT id, name, mobile_number 
FROM mobile_users
WHERE name
IN('raj', 'gaurang', 'nishidh'); 

BETWEEN is used to selects values within a given range. Values can be numbers, text, dates.

SYNTAX
SELECT comma_separated_column_names
FROM table_name
WHERE column_name
BETWEEN val1 AND val2;

EXAMPLE
SELECT id, name
FROM users
WHERE id
BETWEEN 100 AND 110;