Operator Index

Operator Index

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

Symbols

[ index top ]

-

Section 14.6.1, “Arithmetic Operators”
Section 14.10, “Cast Functions and Operators”
Section 11.5, “Expressions”
Section 13.1.1, “Numeric Data Type Syntax”
Section 26.6, “Restrictions and Limitations on Partitioning”

!

Section 11.5, “Expressions”
Section 14.4.3, “Logical Operators”
Section 14.4.1, “Operator Precedence”

!=

Section 14.4.2, “Comparison Functions and Operators”
Section 14.4.1, “Operator Precedence”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”

%

Section 14.6.1, “Arithmetic Operators”

&

Section 14.12, “Bit Functions and Operators”
Section 15.1.24, “CREATE TABLE Statement”
Section 26.6, “Restrictions and Limitations on Partitioning”

&&

Section 14.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”

>

Section 14.4.2, “Comparison Functions and Operators”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”

->

Section 14.17.3, “Functions That Search JSON Values”
Section 15.1.24.9, “Secondary Indexes and Generated Columns”
Section 13.5, “The JSON Data Type”

>>

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

->>

Section 15.1.18, “CREATE INDEX Statement”
Section 15.1.24.9, “Secondary Indexes and Generated Columns”
Section 13.5, “The JSON Data Type”

>=

Section 14.4.2, “Comparison Functions and Operators”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”

<

Section 14.4.2, “Comparison Functions and Operators”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”
Section 5.3.4.6, “Working with NULL Values”

<>

Section 14.4.2, “Comparison Functions and Operators”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”
Section 5.3.4.6, “Working with NULL Values”

<<

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

<=

Section 14.4.2, “Comparison Functions and Operators”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”

<=>

Section 14.4.2, “Comparison Functions and Operators”
Section 15.2.15.7, “Correlated Subqueries”
Section 10.15.12, “Example”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”
Section 14.3, “Type Conversion in Expression Evaluation”

*

Section 14.6.1, “Arithmetic Operators”
Section 13.1.1, “Numeric Data Type Syntax”
Section 26.6, “Restrictions and Limitations on Partitioning”

+

Section 14.6.1, “Arithmetic Operators”
Section 14.10, “Cast Functions and Operators”
Section 11.5, “Expressions”
Section 13.1.1, “Numeric Data Type Syntax”
Section 26.6, “Restrictions and Limitations on Partitioning”

/

Section 14.6.1, “Arithmetic Operators”
Section 26.6, “Restrictions and Limitations on Partitioning”
Section 7.1.8, “Server System Variables”

:=

Section 14.4.4, “Assignment Operators”
Section 14.4.1, “Operator Precedence”
Section 15.7.6.1, “SET Syntax for Variable Assignment”
Section 11.4, “User-Defined Variables”

=

Section 14.4.4, “Assignment Operators”
Section 14.4.2, “Comparison Functions and Operators”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 15.2.15.7, “Correlated Subqueries”
Section 10.8.2, “EXPLAIN Output Format”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 10.2.1.2, “Range Optimization”
Section 15.2.15.12, “Restrictions on Subqueries”
Section 15.7.6.1, “SET Syntax for Variable Assignment”
Section 14.8.1, “String Comparison Functions and Operators”
Section 13.5, “The JSON Data Type”
Section 11.4, “User-Defined Variables”
Section 5.3.4.6, “Working with NULL Values”

^

Section 14.12, “Bit Functions and Operators”
Section 11.5, “Expressions”
Section 14.4.1, “Operator Precedence”
Section 26.6, “Restrictions and Limitations on Partitioning”

|

Section 14.12, “Bit Functions and Operators”
Section 26.6, “Restrictions and Limitations on Partitioning”

||

Section 14.8.3, “Character Set and Collation of Function Results”
Section 12.8.2, “COLLATE Clause Precedence”
Section 11.5, “Expressions”
Section 14.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 7.1.11, “Server SQL Modes”

~

Section 14.12, “Bit Functions and Operators”
Section 26.6, “Restrictions and Limitations on Partitioning”

A

[ index top ]

AND

Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 15.1.17, “CREATE JSON DUALITY VIEW Statement”
Section 15.1.24, “CREATE TABLE Statement”
Section 10.2.1.3, “Index Merge Optimization”
Section 14.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 10.2.2.6, “Optimizing ANY and ALL Subqueries”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 10.2.1.2, “Range Optimization”
Section 15.2.15.12, “Restrictions on Subqueries”
Section 10.2.1.22, “Row Constructor Expression Optimization”
Section 5.6.7, “Searching on Two Keys”
Section 22.3.4.2, “Select Tables”
Section 22.4.4.2, “Select Tables”
Section 5.3.4.2, “Selecting Particular Rows”
Section 14.8.1, “String Comparison Functions and Operators”
Section 27.6.2, “View Processing Algorithms”

B

[ index top ]

BETWEEN

Section 14.4.2, “Comparison Functions and Operators”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 10.2.1.13, “Condition Filtering”
Section 10.8.2, “EXPLAIN Output Format”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 15.5.1, “PREPARE Statement”
Section 10.2.1.2, “Range Optimization”
Section 13.5, “The JSON Data Type”
Section 14.3, “Type Conversion in Expression Evaluation”

BINARY

Section 14.12, “Bit Functions and Operators”
Section 14.10, “Cast Functions and Operators”
Section 10.4.2.2, “Optimizing for Character and String Types”
Section 5.3.4.7, “Pattern Matching”
Section 5.3.4.4, “Sorting Rows”

C

[ index top ]

CASE

Section 15.6.5.1, “CASE Statement”
Section 11.5, “Expressions”
Section 14.5, “Flow Control Functions”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 15.5.1, “PREPARE Statement”
Section 13.3.5, “The VECTOR Type”

CASE value WHEN compare_value THEN result END

Section 14.5, “Flow Control Functions”

CASE WHEN condition THEN result END

Section 14.5, “Flow Control Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 14.5, “Flow Control Functions”

column->>path

Section 14.17.3, “Functions That Search JSON Values”

column->path

Section 14.17.3, “Functions That Search JSON Values”
Section 13.5, “The JSON Data Type”

D

[ index top ]

DIV

Section 14.6.1, “Arithmetic Operators”
Section 26.6, “Restrictions and Limitations on Partitioning”

E

[ index top ]

EXISTS

Section 10.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin and Antijoin Transformations”

EXISTS()

Section 14.4.2, “Comparison Functions and Operators”

expr BETWEEN min AND max

Section 14.4.2, “Comparison Functions and Operators”

expr IN ()

Section 14.4.2, “Comparison Functions and Operators”

expr LIKE pat

Section 14.8.1, “String Comparison Functions and Operators”

expr NOT BETWEEN min AND max

Section 14.4.2, “Comparison Functions and Operators”

expr NOT IN ()

Section 14.4.2, “Comparison Functions and Operators”

expr NOT LIKE pat

Section 14.8.1, “String Comparison Functions and Operators”

expr NOT REGEXP pat

Section 14.8.2, “Regular Expressions”

expr NOT RLIKE pat

Section 14.8.2, “Regular Expressions”

expr REGEXP pat

Section 14.8.2, “Regular Expressions”

expr RLIKE pat

Section 14.8.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 14.8, “String Functions and Operators”

I

[ index top ]

IN

Section 10.2.2.6, “Optimizing ANY and ALL Subqueries”
Section 10.2.2.1, “Optimizing IN and EXISTS Subquery Predicates with Semijoin and Antijoin Transformations”

IN()

Section 10.8.2, “EXPLAIN Output Format”
Section 14.4.1, “Operator Precedence”
Section 10.3.11, “Optimizer Use of Generated Column Indexes”
Section 10.2.1.2, “Range Optimization”
Section 10.2.1.22, “Row Constructor Expression Optimization”
Section 13.5, “The JSON Data Type”
Section 14.3, “Type Conversion in Expression Evaluation”

IS

Section 14.4.1, “Operator Precedence”

IS boolean_value

Section 14.4.2, “Comparison Functions and Operators”

IS NOT boolean_value

Section 14.4.2, “Comparison Functions and Operators”

IS NOT NULL

Section 14.4.2, “Comparison Functions and Operators”
Section B.3.4.3, “Problems with NULL Values”
Section 10.2.1.2, “Range Optimization”
Section 5.3.4.6, “Working with NULL Values”

IS NULL

Section 14.4.2, “Comparison Functions and Operators”
Section 10.8.2, “EXPLAIN Output Format”
Section 10.2.1.15, “IS NULL Optimization”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section B.3.4.3, “Problems with NULL Values”
Section 10.2.1.2, “Range Optimization”
Section 7.1.8, “Server System Variables”
Section 5.3.4.6, “Working with NULL Values”

L

[ index top ]

LIKE

Section 8.2.7, “Access Control, Stage 2: Request Verification”
Section 14.10, “Cast Functions and Operators”
Section 12.2, “Character Sets and Collations in MySQL”
Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 10.8.2, “EXPLAIN Output Format”
Section 28.8, “Extensions to SHOW Statements”
Section 14.17.3, “Functions That Search JSON Values”
Section 15.8.3, “HELP Statement”
Section A.11, “MySQL 9.5 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 6.5.1.4, “mysql Client Server-Side Help”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 25.7.4, “NDB Cluster Replication Schema and Tables”
Section 14.4.1, “Operator Precedence”
Section 5.3.4.7, “Pattern Matching”
Section 29.4.4, “Pre-Filtering by Instrument”
Section 25.6.18, “Quick Reference: NDB Cluster SQL Statements”
Section 10.2.1.2, “Range Optimization”
Section 19.1.6.3, “Replica Server Options and Variables”
Section 19.2.5.4, “Replication Channel Based Filters”
Section 7.1.11, “Server SQL Modes”
Section 15.7.7.4, “SHOW CHARACTER SET Statement”
Section 15.7.7.5, “SHOW COLLATION Statement”
Section 15.7.7.6, “SHOW COLUMNS Statement”
Section 15.7.7.16, “SHOW DATABASES Statement”
Section 15.7.7.20, “SHOW EVENTS Statement”
Section 15.7.7.26, “SHOW OPEN TABLES Statement”
Section 15.7.7.31, “SHOW PROCEDURE STATUS Statement”
Section 15.7.7.38, “SHOW STATUS Statement”
Section 15.7.7.39, “SHOW TABLE STATUS Statement”
Section 15.7.7.40, “SHOW TABLES Statement”
Section 15.7.7.41, “SHOW TRIGGERS Statement”
Section 15.7.7.42, “SHOW VARIABLES Statement”
Section 8.2.4, “Specifying Account Names”
Section 14.8.1, “String Comparison Functions and Operators”
Section 11.1.1, “String Literals”
Section 7.1.9.5, “Structured System Variables”
Section 12.8.5, “The binary Collation Compared to _bin Collations”
Section 30.4.4.5, “The ps_setup_disable_consumer() Procedure”
Section 30.4.4.6, “The ps_setup_disable_instrument() Procedure”
Section 30.4.4.9, “The ps_setup_enable_consumer() Procedure”
Section 30.4.4.10, “The ps_setup_enable_instrument() Procedure”
Section 13.3.7, “The SET Type”
Section 7.1.9, “Using System Variables”

LIKE '_A%'

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

LIKE 'pattern'

Section 10.2.1.2, “Range Optimization”
Section 15.7.7, “SHOW Statements”

M

[ index top ]

MEMBER OF()

Section 15.1.18, “CREATE INDEX Statement”
Section 14.17.3, “Functions That Search JSON Values”

N

[ index top ]

N % M

Section 14.6.1, “Arithmetic Operators”
Section 14.6.2, “Mathematical Functions”

N MOD M

Section 14.6.1, “Arithmetic Operators”
Section 14.6.2, “Mathematical Functions”

NOT

Section 14.4.3, “Logical Operators”
Section 7.1.11, “Server SQL Modes”

NOT EXISTS()

Section 14.4.2, “Comparison Functions and Operators”

NOT IN

Section 10.2.2.6, “Optimizing ANY and ALL Subqueries”

NOT IN()

Section 10.2.1.2, “Range Optimization”

NOT LIKE

Section 5.3.4.7, “Pattern Matching”
Section 14.8.1, “String Comparison Functions and Operators”

NOT REGEXP

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

NOT RLIKE

Section 14.8.1, “String Comparison Functions and Operators”

O

[ index top ]

OR

Section 15.1.17, “CREATE JSON DUALITY VIEW Statement”
Section 11.5, “Expressions”
Section 15.7.1.6, “GRANT Statement”
Section 10.2.1.3, “Index Merge Optimization”
Section 14.4.3, “Logical Operators”
Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 10.2.2.3, “Optimizing Subqueries with the EXISTS Strategy”
Section 10.2.1.2, “Range Optimization”
Section 10.2.1.22, “Row Constructor Expression Optimization”
Section 5.6.7, “Searching on Two Keys”
Section 22.3.4.2, “Select Tables”
Section 22.4.4.2, “Select Tables”
Section 5.3.4.2, “Selecting Particular Rows”
Section 7.1.11, “Server SQL Modes”
Section 14.8.1, “String Comparison Functions and Operators”

R

[ index top ]

REGEXP

Section 1.7.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 5.3.4.7, “Pattern Matching”
Section 14.8.2, “Regular Expressions”
Section 12.11, “Restrictions on Character Sets”

RLIKE

Section 5.3.4.7, “Pattern Matching”
Section 14.8.2, “Regular Expressions”
Section 12.11, “Restrictions on Character Sets”

V

[ index top ]

value MEMBER OF()

Section 14.17.3, “Functions That Search JSON Values”

X

[ index top ]

XOR

Section 14.19.1, “Aggregate Function Descriptions”
Section 14.4.3, “Logical Operators”