MySQL :: MySQL 8.0 Reference Manual :: Operator Index

Skip to Main Content

The world's most popular open source database

Developer Zone Downloads MySQL.com

Documentation

Section Menu:

version 8.0

9.1
9.0
8.4 current
5.7

MySQL 8.0 Reference Manual / Indexes / Operator Index

Operator Index

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

Symbols

-

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 1.3, “What Is New in MySQL 8.0”

!=

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 1.3, “What Is New in MySQL 8.0”

%

Section 14.6.1, “Arithmetic Operators”

&

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

&&

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

>

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.6.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 1.3, “What Is New in MySQL 8.0”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.0”

->

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

>>

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

->>

Section 15.1.15, “CREATE INDEX Statement”
Section 15.1.20.9, “Secondary Indexes and Generated Columns”
Section 13.5, “The JSON Data Type”
Section 1.3, “What Is New in MySQL 8.0”

>=

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.6.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 1.3, “What Is New in MySQL 8.0”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.0”

<

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.6.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 1.3, “What Is New in MySQL 8.0”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.0”
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.6.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 1.3, “What Is New in MySQL 8.0”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.0”
Section 5.3.4.6, “Working with NULL Values”

<<

Section 14.12, “Bit Functions and Operators”
Section 1.6.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.6.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 1.3, “What Is New in MySQL 8.0”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.0”

<=>

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.6.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 1.3, “What Is New in MySQL 8.0”

*

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.6.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 1.3, “What Is New in MySQL 8.0”
Section 25.2.4, “What is New in MySQL NDB Cluster 8.0”
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.6.1, “MySQL Extensions to Standard SQL”
Section 14.4.1, “Operator Precedence”
Section 7.1.11, “Server SQL Modes”
Section 1.3, “What Is New in MySQL 8.0”

~

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

A

AND

Section 10.3.9, “Comparison of B-Tree and Hash Indexes”
Section 15.1.20, “CREATE TABLE Statement”
Section 10.2.1.3, “Index Merge Optimization”
Section 14.4.3, “Logical Operators”
Section 1.6.1, “MySQL Extensions to Standard SQL”
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.5.2, “View Processing Algorithms”
Section 1.3, “What Is New in MySQL 8.0”

B

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”
Section 1.3, “What Is New in MySQL 8.0”

C

CASE

Section 15.6.5.1, “CASE Statement”
Section 11.5, “Expressions”
Section 14.5, “Flow Control Functions”
Section 1.6.1, “MySQL Extensions to Standard SQL”
Section 15.5.1, “PREPARE Statement”

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”

CASE()

Section 3.5, “Changes in MySQL 8.0”

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

DIV

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

E

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

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

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 8.0 FAQ: MySQL Chinese, Japanese, and Korean Character Sets”
Section 6.5.1.4, “mysql Client Server-Side Help”
Section 1.6.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.19, “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.3, “SHOW CHARACTER SET Statement”
Section 15.7.7.4, “SHOW COLLATION Statement”
Section 15.7.7.5, “SHOW COLUMNS Statement”
Section 15.7.7.14, “SHOW DATABASES Statement”
Section 15.7.7.18, “SHOW EVENTS Statement”
Section 15.7.7.24, “SHOW OPEN TABLES Statement”
Section 15.7.7.28, “SHOW PROCEDURE STATUS Statement”
Section 15.7.7.37, “SHOW STATUS Statement”
Section 15.7.7.38, “SHOW TABLE STATUS Statement”
Section 15.7.7.39, “SHOW TABLES Statement”
Section 15.7.7.40, “SHOW TRIGGERS Statement”
Section 15.7.7.41, “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.6, “The SET Type”
Section 7.1.9, “Using System Variables”

LIKE '_A%'

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

LIKE 'pattern'

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

LIKE ... ESCAPE

Section B.3.7, “Known Issues in MySQL”

M

MEMBER OF()

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

N

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”
Section 1.3, “What Is New in MySQL 8.0”

NOT EXISTS()

Section 14.4.2, “Comparison Functions and Operators”

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.6.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

OR

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.6.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”
Section 1.3, “What Is New in MySQL 8.0”

R

REGEXP

Section 1.6.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”
Section 1.3, “What Is New in MySQL 8.0”

RLIKE

Section 5.3.4.7, “Pattern Matching”
Section 14.8.2, “Regular Expressions”
Section 12.11, “Restrictions on Character Sets”
Section 1.3, “What Is New in MySQL 8.0”

V

value MEMBER OF()

Section 14.17.3, “Functions That Search JSON Values”

X

XOR

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

PREV HOME UP NEXT

PDF (US Ltr) - 43.3Mb
PDF (A4) - 43.4Mb
Man Pages (TGZ) - 296.6Kb
Man Pages (Zip) - 401.9Kb
Info (Gzip) - 4.3Mb
Info (Zip) - 4.3Mb