MySQL Tutorial Comparison Functions Operators 52 codes

1 Check to see if the first name is NULL

2 Compare string value using the Greater than ( = ) operator

3 Compare string value using the Greater than or equal( = )

4 Compare string value using the Less than or equal(=) operator

5 Compare string value using the Less than( ) operator

6 Compare string value using the Not equal operator

7 Comparing integer value with less than operator

8 Comparison Functions and Operators

9 Data type conversion in Not equal operator

10 Equal

11 Expr BETWEEN min AND max

12 Expr IN (value, )

13 Greater than

14 Greater than or equal

15 GREATEST(@id1, @id2, @id3, @id4, @id5)

16 GREATEST(value1,value2, ) returns NULL if any argument is NULL

17 GREATEST(value1,value2, ) returns the largest (maximum-valued) argument within two or more arguments

18 INTERVAL(N,N1,N2,N3, )

19 IS boolean_value

20 IS NOT boolean_value

21 IS NOT NULL

22 IS NULL

23 ISNULL(expr)

24 LEAST with float value

25 LEAST() returns NULL if any argument is NULL

26 LEAST(value1,value2, ) returns the smallest (minimum-valued) argument withing two or more arguments

27 Less than

28 Less than or equal

29 Not equal

30 NULL-safe equal

31 SELECT 0 0 = 0

32 SELECT 0 01 = 0

33 SELECT 01 0 01

34 SELECT 2 BETWEEN 2 AND 3

35 SELECT 2 BETWEEN 2 AND x-3

36 SELECT A IN (A,B,C)

37 SELECT b BETWEEN a AND c

38 SELECT COALESCE(NULL,NULL,NULL)

39 SELECT GREATEST(3 0,3 0,5 0,7 0)

40 SELECT GREATEST(B,A,C)

41 SELECT ISNULL(10)

42 String comparisons are not case sensitive

43 Type conversion when using the Equal operator

44 Use GREATEST(value1,value2, ) function with column data

45 Use IN with data in a table

46 Use LEAST with data in a table

47 Using IN with subquery

48 Using ISNULL in where clause

49 Using ISNULL with data in a table

50 Using LEAST with string value

51 Using more than one column with a NOT IN operator

52 You should never mix quoted and unquoted values in an IN list