Operator Index

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

Symbols

[index top]

-

Section 13.6.1, “Arithmetic Operators”
Section 13.10, “Cast Functions and Operators”
Section 13.7, “Date and Time Functions”
Section 12.1.1, “Numeric Type Overview”
Section 20.6, “Restrictions and Limitations on Partitioning”

!

Section 10.5, “Expression Syntax”
Section 13.3.3, “Logical Operators”
Section 13.3.1, “Operator Precedence”

!=

Section 13.3.2, “Comparison Functions and Operators”
Section 13.3.1, “Operator Precedence”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”

%

Section 13.6.1, “Arithmetic Operators”

&

Section 13.12, “Bit Functions and Operators”
Section 14.1.18, “CREATE TABLE Syntax”
Section 20.6, “Restrictions and Limitations on Partitioning”

&&

Section 13.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”

>

Section 13.3.2, “Comparison Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”

->

Section 13.16.3, “Functions That Search JSON Values”
Section 14.1.18.6, “Secondary Indexes and Generated Virtual Columns”

>>

Section 13.12, “Bit Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 20.6, “Restrictions and Limitations on Partitioning”

>=

Section 13.3.2, “Comparison Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”

<

Section 13.3.2, “Comparison Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 4.3.4.6, “Working with NULL Values”

<>

Section 13.3.2, “Comparison Functions and Operators”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 4.3.4.6, “Working with NULL Values”

<<

Section 13.12, “Bit Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 20.6, “Restrictions and Limitations on Partitioning”

<=

Section 13.3.2, “Comparison Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”

<=>

Section 13.3.2, “Comparison Functions and Operators”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 13.2, “Type Conversion in Expression Evaluation”

*

Section 13.6.1, “Arithmetic Operators”
Section 12.1.1, “Numeric Type Overview”
Section 20.6, “Restrictions and Limitations on Partitioning”

+

Section 13.6.1, “Arithmetic Operators”
Section 13.10, “Cast Functions and Operators”
Section 13.7, “Date and Time Functions”
Section 12.1.1, “Numeric Type Overview”
Section 20.6, “Restrictions and Limitations on Partitioning”

/

Section 13.6.1, “Arithmetic Operators”
Section 20.6, “Restrictions and Limitations on Partitioning”
Section 6.1.4, “Server System Variables”

:=

Section 13.3.4, “Assignment Operators”
Section 13.3.1, “Operator Precedence”
Section 14.7.4, “SET Syntax”
Section 10.4, “User-Defined Variables”

=

Section 13.3.4, “Assignment Operators”
Section 13.3.2, “Comparison Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 9.8.2, “EXPLAIN Output Format”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section C.4, “Restrictions on Subqueries”
Section 14.7.4, “SET Syntax”
Section 13.5.1, “String Comparison Functions”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 10.4, “User-Defined Variables”
Section 4.3.4.6, “Working with NULL Values”

^

Section 13.12, “Bit Functions and Operators”
Section 10.5, “Expression Syntax”
Section 13.3.1, “Operator Precedence”
Section 20.6, “Restrictions and Limitations on Partitioning”

|

Section 13.12, “Bit Functions and Operators”
Section 20.6, “Restrictions and Limitations on Partitioning”

||

Section 11.1.8.2, “COLLATE Clause Precedence”
Section 10.5, “Expression Syntax”
Section 13.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 11.1.10.1, “Result Strings”
Section 6.1.7, “Server SQL Modes”

~

Section 13.12, “Bit Functions and Operators”
Section 20.6, “Restrictions and Limitations on Partitioning”

A

[index top]

AND

Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 14.1.18, “CREATE TABLE Syntax”
Section 9.2.1.4, “Index Merge Optimization”
Section 9.2.1.3.4, “Limiting Memory Use for Range Optimization”
Section 13.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 9.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section C.4, “Restrictions on Subqueries”
Section 9.2.1.20, “Row Constructor Expression Optimization”
Section 4.6.7, “Searching on Two Keys”
Section 3.4.5.2, “Select Tables”
Section 3.5.5.2, “Select Tables”
Section 4.3.4.2, “Selecting Particular Rows”
Section 13.5.1, “String Comparison Functions”
Section 9.2.1.4.1, “The Index Merge Intersection Access Algorithm”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 21.5.2, “View Processing Algorithms”

B

[index top]

BETWEEN

Section 13.3.2, “Comparison Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 9.8.2, “EXPLAIN Output Format”
Section 9.3.9, “Optimizer Use of Generated Column Indexes”
Section 12.6, “The JSON Data Type”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 13.2, “Type Conversion in Expression Evaluation”

BINARY

Section 13.10, “Cast Functions and Operators”
Section 4.3.4.7, “Pattern Matching”
Section 4.3.4.4, “Sorting Rows”
Section 11.1.8.6, “The BINARY Operator”

BINARY str

Section 13.10, “Cast Functions and Operators”

C

[index top]

CASE

Section 14.6.5.1, “CASE Syntax”
Section 13.4, “Control Flow Functions”
Section 10.5, “Expression Syntax”
Section 1.8.1, “MySQL Extensions to Standard SQL”

CASE value WHEN END

Section 13.4, “Control Flow Functions”

CASE WHEN END

Section 13.4, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 13.4, “Control Flow Functions”

column->>path

Section 13.16.3, “Functions That Search JSON Values”

column->path

Section 13.16.3, “Functions That Search JSON Values”
Section 12.6, “The JSON Data Type”
Section 1.4, “What Is New in MySQL 5.7”

D

[index top]

DIV

Section 13.6.1, “Arithmetic Operators”
Section 20.6, “Restrictions and Limitations on Partitioning”

E

[index top]

expr BETWEEN min AND max

Section 13.3.2, “Comparison Functions and Operators”

expr LIKE pat

Section 13.5.1, “String Comparison Functions”

expr NOT BETWEEN min AND max

Section 13.3.2, “Comparison Functions and Operators”

expr NOT LIKE pat

Section 13.5.1, “String Comparison Functions”

expr NOT REGEXP pat

Section 13.5.2, “Regular Expressions”

expr NOT RLIKE pat

Section 13.5.2, “Regular Expressions”

expr REGEXP pat

Section 13.5.2, “Regular Expressions”

expr RLIKE pat

Section 13.5.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 13.5, “String Functions”

I

[index top]

IS

Section 13.3.1, “Operator Precedence”

IS boolean_value

Section 13.3.2, “Comparison Functions and Operators”

IS NOT boolean_value

Section 13.3.2, “Comparison Functions and Operators”

IS NOT NULL

Section 13.3.2, “Comparison Functions and Operators”
Section B.5.4.3, “Problems with NULL Values”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 4.3.4.6, “Working with NULL Values”

IS NULL

Section 13.3.2, “Comparison Functions and Operators”
Section 9.8.2, “EXPLAIN Output Format”
Section 9.2.1.8, “IS NULL Optimization”
Section 9.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section B.5.4.3, “Problems with NULL Values”
Section 6.1.4, “Server System Variables”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 4.3.4.6, “Working with NULL Values”

L

[index top]

LIKE

Section 7.2.5, “Access Control, Stage 2: Request Verification”
Section 13.10, “Cast Functions and Operators”
Section 9.3.8, “Comparison of B-Tree and Hash Indexes”
Section 22.33, “Extensions to SHOW Statements”
Section 13.16.3, “Functions That Search JSON Values”
Section 14.8.3, “HELP Syntax”
Section A.11, “MySQL 5.7 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 19.6.11, “MySQL Cluster Replication Conflict Resolution”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 5.5.1.4, “mysql Server-Side Help”
Section 13.3.1, “Operator Precedence”
Section 4.3.4.7, “Pattern Matching”
Section 23.2.3.3.1, “Pre-Filtering by Instrument”
Section 19.5.9, “Quick Reference: MySQL Cluster SQL Statements”
Section 18.1.6.3, “Replication Slave Options and Variables”
Section 14.7.5.3, “SHOW CHARACTER SET Syntax”
Section 14.7.5.4, “SHOW COLLATION Syntax”
Section 14.7.5.5, “SHOW COLUMNS Syntax”
Section 14.7.5.14, “SHOW DATABASES Syntax”
Section 14.7.5.18, “SHOW EVENTS Syntax”
Section 14.7.5.24, “SHOW OPEN TABLES Syntax”
Section 14.7.5.28, “SHOW PROCEDURE STATUS Syntax”
Section 11.1.10.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 14.7.5.35, “SHOW STATUS Syntax”
Section 14.7.5.36, “SHOW TABLE STATUS Syntax”
Section 14.7.5.37, “SHOW TABLES Syntax”
Section 14.7.5.38, “SHOW TRIGGERS Syntax”
Section 14.7.5.39, “SHOW VARIABLES Syntax”
Section 7.2.3, “Specifying Account Names”
Section 13.5.1, “String Comparison Functions”
Section 10.1.1, “String Literals”
Section 6.1.5.1, “Structured System Variables”
Section 12.4.1, “The CHAR and VARCHAR Types”
Section 24.4.4.5, “The ps_setup_disable_consumer() Procedure”
Section 24.4.4.6, “The ps_setup_disable_instrument() Procedure”
Section 24.4.4.9, “The ps_setup_enable_consumer() Procedure”
Section 24.4.4.10, “The ps_setup_enable_instrument() Procedure”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 12.4.5, “The SET Type”
Section 6.1.5, “Using System Variables”

LIKE '_A%'

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

LIKE 'pattern'

Section 14.7.5, “SHOW Syntax”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”

LIKE ... ESCAPE

Section B.5.7, “Known Issues in MySQL”

N

[index top]

N % M

Section 13.6.1, “Arithmetic Operators”
Section 13.6.2, “Mathematical Functions”

N MOD M

Section 13.6.1, “Arithmetic Operators”
Section 13.6.2, “Mathematical Functions”

NOT

Section 13.3.3, “Logical Operators”
Section 6.1.7, “Server SQL Modes”

NOT LIKE

Section 4.3.4.7, “Pattern Matching”
Section 13.5.1, “String Comparison Functions”

NOT REGEXP

Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 4.3.4.7, “Pattern Matching”
Section 13.5.1, “String Comparison Functions”

NOT RLIKE

Section 4.3.4.7, “Pattern Matching”
Section 13.5.1, “String Comparison Functions”

O

[index top]

OR

Section 10.5, “Expression Syntax”
Section 14.7.1.4, “GRANT Syntax”
Section 9.2.1.4, “Index Merge Optimization”
Section 9.2.1.3.4, “Limiting Memory Use for Range Optimization”
Section 13.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 9.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section 9.2.1.20, “Row Constructor Expression Optimization”
Section 4.6.7, “Searching on Two Keys”
Section 3.4.5.2, “Select Tables”
Section 3.5.5.2, “Select Tables”
Section 4.3.4.2, “Selecting Particular Rows”
Section 6.1.7, “Server SQL Modes”
Section 13.5.1, “String Comparison Functions”
Section 9.2.1.4.3, “The Index Merge Sort-Union Access Algorithm”
Section 9.2.1.4.2, “The Index Merge Union Access Algorithm”
Section 9.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 9.2.1.3.1, “The Range Access Method for Single-Part Indexes”

R

[index top]

REGEXP

Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 13.3.1, “Operator Precedence”
Section 4.3.4.7, “Pattern Matching”
Section 13.5.2, “Regular Expressions”
Section C.7, “Restrictions on Character Sets”

RLIKE

Section 4.3.4.7, “Pattern Matching”
Section 13.5.2, “Regular Expressions”
Section C.7, “Restrictions on Character Sets”

X

[index top]

XOR

Section 13.20.1, “Aggregate (GROUP BY) Function Descriptions”
Section 13.3.3, “Logical Operators”