Operator Index
Prev   Next

Operator Index

!

Section 11.2.4, “Logical Operators”
Section 11.2.1, “Operator Precedence”

!=

Section 11.2.3, “Comparison Functions and Operators”

%

Section 11.5.1, “Arithmetic Operators”

&

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”

&&

Section 11.2.4, “Logical Operators”

*

Section 11.5.1, “Arithmetic Operators”
Section 10.1.1, “Overview of Numeric Types”
Section 18.5, “Restrictions and Limitations on Partitioning”

+

Section 11.5.1, “Arithmetic Operators”
Section 11.9, “Cast Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 10.1.1, “Overview of Numeric Types”

-

Section 11.5.1, “Arithmetic Operators”
Section 11.9, “Cast Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 10.1.1, “Overview of Numeric Types”

/

Section 11.5.1, “Arithmetic Operators”
Section 18.5, “Restrictions and Limitations on Partitioning”

<

Section 11.2.3, “Comparison Functions and Operators”

<<

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”

<=

Section 11.2.3, “Comparison Functions and Operators”

<=>

Section 11.2.3, “Comparison Functions and Operators”
Section 11.2.2, “Type Conversion in Expression Evaluation”

<>

Section 11.2.3, “Comparison Functions and Operators”

=

Section 11.2.3, “Comparison Functions and Operators”
Section D.3, “Restrictions on Subqueries”
Section 11.4.1, “String Comparison Functions”

>

Section 11.2.3, “Comparison Functions and Operators”

>=

Section 11.2.3, “Comparison Functions and Operators”

>>

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”

AND

Section 11.2.4, “Logical Operators”
Section D.3, “Restrictions on Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 11.4.1, “String Comparison Functions”
Section 19.5.2, “View Processing Algorithms”

BETWEEN

Section 11.2.3, “Comparison Functions and Operators”

BINARY

Section 9.1.6.3, “BINARY Operator”
Section 11.9, “Cast Functions and Operators”
Section 11.11.2, “Encryption and Compression Functions”
Section 3.3.4.7, “Pattern Matching”
Section 3.3.4.4, “Sorting Rows”

BINARY str

Section 11.9, “Cast Functions and Operators”

CASE

Section 11.3, “Control Flow Functions”

CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END

Section 11.3, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 11.3, “Control Flow Functions”

CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END

Section 11.3, “Control Flow Functions”

DIV

Section 11.5.1, “Arithmetic Operators”
Section 18.5, “Restrictions and Limitations on Partitioning”

IS NOT NULL

Section 11.2.3, “Comparison Functions and Operators”
Section 3.3.4.6, “Working with NULL Values”

IS NOT boolean_value

Section 11.2.3, “Comparison Functions and Operators”

IS NULL

Section 11.2.3, “Comparison Functions and Operators”
Section 3.3.4.6, “Working with NULL Values”

IS boolean_value

Section 11.2.3, “Comparison Functions and Operators”

LIKE

Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 11.9, “Cast Functions and Operators”
Section 20.28, “Extensions to SHOW Statements”
Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”
Section 3.3.4.7, “Pattern Matching”
Section 17.7.7, “Quick Reference: MySQL Cluster SQL Statements”
Section 11.4.1, “String Comparison Functions”
Section 8.1.1, “Strings”
Section 10.4.5, “The SET Type”

LIKE '_A%'

Section A.11, “MySQL 5.1 FAQ — MySQL Chinese, Japanese, and Korean Character Sets”

N % M

Section 11.5.1, “Arithmetic Operators”
Section 11.5.2, “Mathematical Functions”

N MOD M

Section 11.5.2, “Mathematical Functions”

NOT

Section 11.2.4, “Logical Operators”
Section 11.2.1, “Operator Precedence”

NOT LIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.4.1, “String Comparison Functions”

NOT REGEXP

Section 3.3.4.7, “Pattern Matching”
Section 11.4.1, “String Comparison Functions”

NOT RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.4.1, “String Comparison Functions”

OR

Section 11.2.4, “Logical Operators”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 11.4.1, “String Comparison Functions”

REGEXP

Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section D.6, “Restrictions on Character Sets”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section D.6, “Restrictions on Character Sets”

XOR

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.2.4, “Logical Operators”

^

Section 11.11.1, “Bit Functions”
Section 11.2.1, “Operator Precedence”
Section 18.5, “Restrictions and Limitations on Partitioning”

expr BETWEEN min AND max

Section 11.2.3, “Comparison Functions and Operators”

expr LIKE pat [ESCAPE 'escape_char']

Section 11.4.1, “String Comparison Functions”

expr NOT BETWEEN min AND max

Section 11.2.3, “Comparison Functions and Operators”

expr NOT LIKE pat [ESCAPE 'escape_char']

Section 11.4.1, “String Comparison Functions”

expr NOT REGEXP pat

Section 11.4.2, “Regular Expressions”

expr NOT RLIKE pat

Section 11.4.2, “Regular Expressions”

expr REGEXP pat

Section 11.4.2, “Regular Expressions”

expr RLIKE pat

Section 11.4.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 11.4, “String Functions”

|

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”

||

Section 9.1.6.2, “COLLATE Clause Precedence”
Section 11.2.4, “Logical Operators”
Section 11.2.1, “Operator Precedence”
Section 9.1.8.1, “Result Strings”

~

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”
Prev   Next
JOIN Types Index Home Option Index