Operator Index

Symbols | A | B | C | D | E | I | L | M | N | O | R | V | X

Symbols

[index top]

-

Section 12.6.1, “Arithmetic Operators”
Section 12.11, “Cast Functions and Operators”
Section 9.5, “Expressions”
Section 11.1.1, “Numeric Data Type Syntax”
Section 24.6, “Restrictions and Limitations on Partitioning”

!

Section 9.5, “Expressions”
Section 12.4.3, “Logical Operators”
Section 12.4.1, “Operator Precedence”
Section 1.3, “What Is New in MySQL 8.0”

!=

Section 12.4.2, “Comparison Functions and Operators”
Section 12.4.1, “Operator Precedence”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

%

Section 12.6.1, “Arithmetic Operators”

&

Section 12.13, “Bit Functions and Operators”
Section 13.1.20, “CREATE TABLE Statement”
Section 24.6, “Restrictions and Limitations on Partitioning”

&&

Section 12.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 1.3, “What Is New in MySQL 8.0”

>

Section 12.4.2, “Comparison Functions and Operators”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

->

Section 12.18.3, “Functions That Search JSON Values”
Section 13.1.20.9, “Secondary Indexes and Generated Columns”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

>>

Section 12.13, “Bit Functions and Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 24.6, “Restrictions and Limitations on Partitioning”

->>

Section 13.1.15, “CREATE INDEX Statement”
Section 13.1.20.9, “Secondary Indexes and Generated Columns”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

>=

Section 12.4.2, “Comparison Functions and Operators”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

<

Section 12.4.2, “Comparison Functions and Operators”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”
Section 3.3.4.6, “Working with NULL Values”

<>

Section 12.4.2, “Comparison Functions and Operators”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”
Section 3.3.4.6, “Working with NULL Values”

<<

Section 12.13, “Bit Functions and Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 24.6, “Restrictions and Limitations on Partitioning”

<=

Section 12.4.2, “Comparison Functions and Operators”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

<=>

Section 12.4.2, “Comparison Functions and Operators”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 12.3, “Type Conversion in Expression Evaluation”
Section 1.3, “What Is New in MySQL 8.0”

*

Section 12.6.1, “Arithmetic Operators”
Section 11.1.1, “Numeric Data Type Syntax”
Section 24.6, “Restrictions and Limitations on Partitioning”

+

Section 12.6.1, “Arithmetic Operators”
Section 12.11, “Cast Functions and Operators”
Section 9.5, “Expressions”
Section 11.1.1, “Numeric Data Type Syntax”
Section 24.6, “Restrictions and Limitations on Partitioning”

/

Section 12.6.1, “Arithmetic Operators”
Section 24.6, “Restrictions and Limitations on Partitioning”
Section 5.1.8, “Server System Variables”

:=

Section 12.4.4, “Assignment Operators”
Section 12.4.1, “Operator Precedence”
Section 13.7.6.1, “SET Syntax for Variable Assignment”
Section 9.4, “User-Defined Variables”

=

Section 12.4.4, “Assignment Operators”
Section 12.4.2, “Comparison Functions and Operators”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 13.2.11.7, “Correlated Subqueries”
Section 8.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.2, “Range Optimization”
Section 13.2.11.12, “Restrictions on Subqueries”
Section 13.7.6.1, “SET Syntax for Variable Assignment”
Section 12.8.1, “String Comparison Functions and Operators”
Section 11.5, “The JSON Data Type”
Section 9.4, “User-Defined Variables”
Section 1.3, “What Is New in MySQL 8.0”
Section 3.3.4.6, “Working with NULL Values”

^

Section 12.13, “Bit Functions and Operators”
Section 9.5, “Expressions”
Section 12.4.1, “Operator Precedence”
Section 24.6, “Restrictions and Limitations on Partitioning”

|

Section 12.13, “Bit Functions and Operators”
Section 24.6, “Restrictions and Limitations on Partitioning”

||

Section 12.8.3, “Character Set and Collation of Function Results”
Section 10.8.2, “COLLATE Clause Precedence”
Section 9.5, “Expressions”
Section 12.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 5.1.11, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 8.0”

~

Section 12.13, “Bit Functions and Operators”
Section 24.6, “Restrictions and Limitations on Partitioning”

≪=>

Section 13.2.11.7, “Correlated Subqueries”

A

[index top]

AND

Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 13.1.20, “CREATE TABLE Statement”
Section 8.2.1.3, “Index Merge Optimization”
Section 12.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 8.2.1.2, “Range Optimization”
Section 13.2.11.12, “Restrictions on Subqueries”
Section 8.2.1.22, “Row Constructor Expression Optimization”
Section 3.6.7, “Searching on Two Keys”
Section 20.3.4.2, “Select Tables”
Section 20.4.4.2, “Select Tables”
Section 3.3.4.2, “Selecting Particular Rows”
Section 12.8.1, “String Comparison Functions and Operators”
Section 25.5.2, “View Processing Algorithms”
Section 1.3, “What Is New in MySQL 8.0”

B

[index top]

BETWEEN

Section 12.4.2, “Comparison Functions and Operators”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 8.2.1.13, “Condition Filtering”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 13.5.1, “PREPARE Statement”
Section 8.2.1.2, “Range Optimization”
Section 11.5, “The JSON Data Type”
Section 12.3, “Type Conversion in Expression Evaluation”

BINARY

Section 12.13, “Bit Functions and Operators”
Section 12.11, “Cast Functions and Operators”
Section 8.4.2.2, “Optimizing for Character and String Types”
Section 3.3.4.7, “Pattern Matching”
Section 3.3.4.4, “Sorting Rows”

C

[index top]

CASE

Section 13.6.5.1, “CASE Statement”
Section 9.5, “Expressions”
Section 12.5, “Flow Control Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 13.5.1, “PREPARE Statement”

CASE value WHEN compare_value THEN result END

Section 12.5, “Flow Control Functions”

CASE WHEN condition THEN result END

Section 12.5, “Flow Control Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 12.5, “Flow Control Functions”

column->>path

Section 12.18.3, “Functions That Search JSON Values”

column->path

Section 12.18.3, “Functions That Search JSON Values”
Section 11.5, “The JSON Data Type”

D

[index top]

DIV

Section 12.6.1, “Arithmetic Operators”
Section 24.6, “Restrictions and Limitations on Partitioning”

E

[index top]

expr BETWEEN min AND max

Section 12.4.2, “Comparison Functions and Operators”

expr IN ()

Section 12.4.2, “Comparison Functions and Operators”

expr LIKE pat

Section 12.8.1, “String Comparison Functions and Operators”

expr NOT BETWEEN min AND max

Section 12.4.2, “Comparison Functions and Operators”

expr NOT IN ()

Section 12.4.2, “Comparison Functions and Operators”

expr NOT LIKE pat

Section 12.8.1, “String Comparison Functions and Operators”

expr NOT REGEXP pat

Section 12.8.2, “Regular Expressions”

expr NOT RLIKE pat

Section 12.8.2, “Regular Expressions”

expr REGEXP pat

Section 12.8.2, “Regular Expressions”

expr RLIKE pat

Section 12.8.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 12.8, “String Functions and Operators”

I

[index top]

IN()

Section 8.8.2, “EXPLAIN Output Format”
Section 12.4.1, “Operator Precedence”
Section 8.3.11, “Optimizer Use of Generated Column Indexes”
Section 8.2.1.2, “Range Optimization”
Section 8.2.1.22, “Row Constructor Expression Optimization”
Section 11.5, “The JSON Data Type”
Section 12.3, “Type Conversion in Expression Evaluation”

IS

Section 12.4.1, “Operator Precedence”

IS boolean_value

Section 12.4.2, “Comparison Functions and Operators”

IS NOT boolean_value

Section 12.4.2, “Comparison Functions and Operators”

IS NOT NULL

Section 12.4.2, “Comparison Functions and Operators”
Section B.3.4.3, “Problems with NULL Values”
Section 8.2.1.2, “Range Optimization”
Section 3.3.4.6, “Working with NULL Values”

IS NULL

Section 12.4.2, “Comparison Functions and Operators”
Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.15, “IS NULL Optimization”
Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section B.3.4.3, “Problems with NULL Values”
Section 8.2.1.2, “Range Optimization”
Section 5.1.8, “Server System Variables”
Section 3.3.4.6, “Working with NULL Values”

L

[index top]

LIKE

Section 6.2.7, “Access Control, Stage 2: Request Verification”
Section 12.11, “Cast Functions and Operators”
Section 10.2, “Character Sets and Collations in MySQL”
Section 8.3.9, “Comparison of B-Tree and Hash Indexes”
Section 8.8.2, “EXPLAIN Output Format”
Section 26.55, “Extensions to SHOW Statements”
Section 12.18.3, “Functions That Search JSON Values”
Section 13.8.3, “HELP Statement”
Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 4.5.1.4, “mysql Client Server-Side Help”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 23.6.11, “NDB Cluster Replication Conflict Resolution”
Section 12.4.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 27.4.4, “Pre-Filtering by Instrument”
Section 23.5.16, “Quick Reference: NDB Cluster SQL Statements”
Section 8.2.1.2, “Range Optimization”
Section 17.1.6.3, “Replica Server Options and Variables”
Section 5.1.11, “Server SQL Modes”
Section 13.7.7.3, “SHOW CHARACTER SET Statement”
Section 13.7.7.4, “SHOW COLLATION Statement”
Section 13.7.7.5, “SHOW COLUMNS Statement”
Section 13.7.7.14, “SHOW DATABASES Statement”
Section 13.7.7.18, “SHOW EVENTS Statement”
Section 13.7.7.24, “SHOW OPEN TABLES Statement”
Section 13.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 13.7.7.37, “SHOW STATUS Statement”
Section 13.7.7.38, “SHOW TABLE STATUS Statement”
Section 13.7.7.39, “SHOW TABLES Statement”
Section 13.7.7.40, “SHOW TRIGGERS Statement”
Section 13.7.7.41, “SHOW VARIABLES Statement”
Section 6.2.4, “Specifying Account Names”
Section 12.8.1, “String Comparison Functions and Operators”
Section 9.1.1, “String Literals”
Section 5.1.9.5, “Structured System Variables”
Section 10.8.5, “The binary Collation Compared to _bin Collations”
Section 28.4.4.5, “The ps_setup_disable_consumer() Procedure”
Section 28.4.4.6, “The ps_setup_disable_instrument() Procedure”
Section 28.4.4.9, “The ps_setup_enable_consumer() Procedure”
Section 28.4.4.10, “The ps_setup_enable_instrument() Procedure”
Section 11.3.6, “The SET Type”
Section 5.1.9, “Using System Variables”

LIKE '_A%'

Section A.11, “MySQL 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”

LIKE 'pattern'

Section 8.2.1.2, “Range Optimization”
Section 13.7.7, “SHOW Statements”

LIKE ... ESCAPE

Section B.3.7, “Known Issues in MySQL”

M

[index top]

MEMBER OF()

Section 13.1.15, “CREATE INDEX Statement”
Section 12.18.3, “Functions That Search JSON Values”
Section 1.3, “What Is New in MySQL 8.0”

N

[index top]

N % M

Section 12.6.1, “Arithmetic Operators”
Section 12.6.2, “Mathematical Functions”

N MOD M

Section 12.6.1, “Arithmetic Operators”
Section 12.6.2, “Mathematical Functions”

NOT

Section 12.4.3, “Logical Operators”
Section 5.1.11, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 8.0”

NOT IN()

Section 8.2.1.2, “Range Optimization”

NOT LIKE

Section 3.3.4.7, “Pattern Matching”
Section 12.8.1, “String Comparison Functions and Operators”

NOT REGEXP

Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.8.1, “String Comparison Functions and Operators”

NOT RLIKE

Section 12.8.1, “String Comparison Functions and Operators”

O

[index top]

OR

Section 9.5, “Expressions”
Section 13.7.1.6, “GRANT Statement”
Section 8.2.1.3, “Index Merge Optimization”
Section 12.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 8.2.1.2, “Range Optimization”
Section 8.2.1.22, “Row Constructor Expression Optimization”
Section 3.6.7, “Searching on Two Keys”
Section 20.3.4.2, “Select Tables”
Section 20.4.4.2, “Select Tables”
Section 3.3.4.2, “Selecting Particular Rows”
Section 5.1.11, “Server SQL Modes”
Section 12.8.1, “String Comparison Functions and Operators”
Section 1.3, “What Is New in MySQL 8.0”

R

[index top]

REGEXP

Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 12.4.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 12.8.2, “Regular Expressions”
Section 10.11, “Restrictions on Character Sets”
Section 1.3, “What Is New in MySQL 8.0”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 12.8.2, “Regular Expressions”
Section 10.11, “Restrictions on Character Sets”
Section 1.3, “What Is New in MySQL 8.0”

V

[index top]

value MEMBER OF()

Section 12.18.3, “Functions That Search JSON Values”

X

[index top]

XOR

Section 12.20.1, “Aggregate Function Descriptions”
Section 12.4.3, “Logical Operators”