Skip navigation links
MySQL 5.6 Reference Manual :: Operator Index
Option Index »
Section Navigation      [Toggle]

Operator Index

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

Symbols

[index top]

-

Section 12.6.1, “Arithmetic Operators”
Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”
Section 11.1.1, “Numeric Type Overview”
Section 18.6, “Restrictions and Limitations on Partitioning”

!

Section 9.5, “Expression Syntax”
Section 12.3.3, “Logical Operators”
Section 12.3.1, “Operator Precedence”

!=

Section 12.3.2, “Comparison Functions and Operators”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

%

Section 12.6.1, “Arithmetic Operators”

&

Section 13.1.17, “CREATE TABLE Syntax”
Section 12.12, “Bit Functions”
Section 18.6, “Restrictions and Limitations on Partitioning”

&&

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

>

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

>>

Section 12.12, “Bit Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 18.6, “Restrictions and Limitations on Partitioning”

>=

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

<

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

<>

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

<<

Section 12.12, “Bit Functions”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 18.6, “Restrictions and Limitations on Partitioning”

<=

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”

<=>

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 12.2, “Type Conversion in Expression Evaluation”

*

Section 12.6.1, “Arithmetic Operators”
Section 11.1.1, “Numeric Type Overview”
Section 18.6, “Restrictions and Limitations on Partitioning”

+

Section 12.6.1, “Arithmetic Operators”
Section 12.10, “Cast Functions and Operators”
Section 12.7, “Date and Time Functions”
Section 11.1.1, “Numeric Type Overview”
Section 18.6, “Restrictions and Limitations on Partitioning”

/

Section 12.6.1, “Arithmetic Operators”
Section 18.6, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”

=

Section 8.8.2, “EXPLAIN Output Format”
Section 13.7.4, “SET Syntax”
Section 12.3.4, “Assignment Operators”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section E.4, “Restrictions on Subqueries”
Section 12.5.1, “String Comparison Functions”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 9.4, “User-Defined Variables”
Section 3.3.4.6, “Working with NULL Values”

^

Section 12.12, “Bit Functions”
Section 9.5, “Expression Syntax”
Section 12.3.1, “Operator Precedence”
Section 18.6, “Restrictions and Limitations on Partitioning”

|

Section 12.12, “Bit Functions”
Section 18.6, “Restrictions and Limitations on Partitioning”

||

Section 10.1.7.3, “COLLATE Clause Precedence”
Section 9.5, “Expression Syntax”
Section 12.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 10.1.9.1, “Result Strings”
Section 5.1.7, “Server SQL Modes”

~

Section 12.12, “Bit Functions”
Section 18.6, “Restrictions and Limitations on Partitioning”

A

[index top]

AND

Section 13.1.17, “CREATE TABLE Syntax”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 8.2.1.4, “Index Merge Optimization”
Section 12.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section E.4, “Restrictions on Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 12.5.1, “String Comparison Functions”
Section 8.2.1.4.1, “The Index Merge Intersection Access Algorithm”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 19.5.2, “View Processing Algorithms”

B

[index top]

BETWEEN

Section 8.8.2, “EXPLAIN Output Format”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 12.2, “Type Conversion in Expression Evaluation”

BINARY

Section 12.10, “Cast Functions and Operators”
Section 3.3.4.7, “Pattern Matching”
Section 3.3.4.4, “Sorting Rows”
Section 10.1.7.7, “The BINARY Operator”

BINARY str

Section 12.10, “Cast Functions and Operators”

C

[index top]

CASE

Section 13.6.5.1, “CASE Syntax”
Section 12.4, “Control Flow Functions”
Section 9.5, “Expression Syntax”
Section 1.8.1, “MySQL Extensions to Standard SQL”

CASE value WHEN END

Section 12.4, “Control Flow Functions”

CASE WHEN END

Section 12.4, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 12.4, “Control Flow Functions”

D

[index top]

DIV

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

E

[index top]

expr BETWEEN min AND max

Section 12.3.2, “Comparison Functions and Operators”

expr LIKE pat

Section 12.5.1, “String Comparison Functions”

expr NOT BETWEEN min AND max

Section 12.3.2, “Comparison Functions and Operators”

expr NOT LIKE pat

Section 12.5.1, “String Comparison Functions”

expr NOT REGEXP pat

Section 12.5.2, “Regular Expressions”

expr NOT RLIKE pat

Section 12.5.2, “Regular Expressions”

expr REGEXP pat

Section 12.5.2, “Regular Expressions”

expr RLIKE pat

Section 12.5.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 12.5, “String Functions”

I

[index top]

IS

Section 12.3.1, “Operator Precedence”

IS boolean_value

Section 12.3.2, “Comparison Functions and Operators”

IS NOT boolean_value

Section 12.3.2, “Comparison Functions and Operators”

IS NOT NULL

Section 12.3.2, “Comparison Functions and Operators”
Section C.5.5.3, “Problems with NULL Values”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

IS NULL

Section 8.8.2, “EXPLAIN Output Format”
Section 8.2.1.8, “IS NULL Optimization”
Section 12.3.2, “Comparison Functions and Operators”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section C.5.5.3, “Problems with NULL Values”
Section 5.1.4, “Server System Variables”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

L

[index top]

LIKE

Section 4.5.1.4, “mysql Server-Side Help”
Section 13.8.3, “HELP Syntax”
Section 13.7.5.4, “SHOW CHARACTER SET Syntax”
Section 13.7.5.5, “SHOW COLLATION Syntax”
Section 13.7.5.6, “SHOW COLUMNS Syntax”
Section 13.7.5.15, “SHOW DATABASES Syntax”
Section 13.7.5.19, “SHOW EVENTS Syntax”
Section 13.7.5.25, “SHOW OPEN TABLES Syntax”
Section 13.7.5.29, “SHOW PROCEDURE STATUS Syntax”
Section 13.7.5.36, “SHOW STATUS Syntax”
Section 13.7.5.37, “SHOW TABLE STATUS Syntax”
Section 13.7.5.38, “SHOW TABLES Syntax”
Section 13.7.5.39, “SHOW TRIGGERS Syntax”
Section 13.7.5.40, “SHOW VARIABLES Syntax”
Section 10.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 6.2.5, “Access Control, Stage 2: Request Verification”
Section 12.10, “Cast Functions and Operators”
Section 8.3.8, “Comparison of B-Tree and Hash Indexes”
Section 20.32, “Extensions to SHOW Statements”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 21.2.3.3.1, “Pre-Filtering by Instrument”
Section 17.5.9, “Quick Reference: MySQL Cluster SQL Statements”
Section 16.1.4.3, “Replication Slave Options and Variables”
Section 6.2.3, “Specifying Account Names”
Section 12.5.1, “String Comparison Functions”
Section 9.1.1, “String Literals”
Section 5.1.5.1, “Structured System Variables”
Section 11.4.1, “The CHAR and VARCHAR Types”
Section 11.4.5, “The SET Type”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.2.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 5.1.5, “Using System Variables”

LIKE 'pattern'

Section 13.7.5, “SHOW Syntax”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”

LIKE ... ESCAPE

Section C.5.8, “Known Issues in MySQL”

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.3.3, “Logical Operators”
Section 5.1.7, “Server SQL Modes”

NOT LIKE

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

NOT REGEXP

Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 3.3.4.7, “Pattern Matching”
Section 12.5.1, “String Comparison Functions”

NOT RLIKE

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

O

[index top]

OR

Section 13.7.1.4, “GRANT Syntax”
Section 9.5, “Expression Syntax”
Section 8.2.1.4, “Index Merge Optimization”
Section 12.3.3, “Logical Operators”
Section 1.8.1, “MySQL Extensions to Standard SQL”
Section 12.3.1, “Operator Precedence”
Section 8.2.1.18.4, “Optimizing Subqueries with EXISTS Strategy”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 5.1.7, “Server SQL Modes”
Section 12.5.1, “String Comparison Functions”
Section 8.2.1.4.3, “The Index Merge Sort-Union Access Algorithm”
Section 8.2.1.4.2, “The Index Merge Union Access Algorithm”
Section 8.2.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 8.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 12.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 12.5.2, “Regular Expressions”
Section E.7, “Restrictions on Character Sets”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 12.5.2, “Regular Expressions”
Section E.7, “Restrictions on Character Sets”

X

[index top]

XOR

Section 12.17.1, “GROUP BY (Aggregate) Functions”
Section 12.3.3, “Logical Operators”

Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices