MySQL Comparison Functions and Operators

#	Function	Description
1	BETWEEN ... AND ...	Check whether a value is within a range of values
2	COALESCE	Return the first non-NULL argument
3	<=>	NULL-safe equal to operator
4	=	Equal operator
5	>=	Greater than or equal operator
6	>	Greater than operator
7	GREATEST	return the largest argument
8	IN	Check whether a value is within a set of values
9	INTERVAL	Return the index of the argument that is less than the first argument
10	IS	Test a value against a boolean
11	IS NULL	Null value test
12	IS NOT	Test a value against a boolean
13	IS NOT NULL	Not NULL value test
14	ISNULL	Test whether the argument is NULL
15	LEAST	Return the smallest argument
16	LIKE	Simple pattern matching
17	NOT BETWEEN ... AND ...	Check whether a value is not within a range of values
18	!=, <>	NOT equal operator
19	<=	Less than or equal operator
20	<	LESS THAN
21	NOT IN	Check whether a value is not within a set of values
22	NOT LIKE	Negation of simple pattern matching
23	STRCMP	Compare two strings