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

Operator Index

!

Section 11.2.4, “Logical Operators”
Section 11.2.1, “Operator Precedence”

!=

Section 11.2.3, “Comparison Functions and Operators”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

%

Section 11.5.1, “Arithmetic Operators”

&

Section 12.1.17, “CREATE TABLE Syntax”
Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”

&&

Section 11.2.4, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”

*

Section 11.5.1, “Arithmetic Operators”
Section 10.1.1, “Overview of Numeric Types”
Section 18.5, “Restrictions and Limitations on Partitioning”

+

Section 11.5.1, “Arithmetic Operators”
Section 11.9, “Cast Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 10.1.1, “Overview of Numeric Types”

-

Section 11.5.1, “Arithmetic Operators”
Section 11.9, “Cast Functions and Operators”
Section 11.6, “Date and Time Functions”
Section 10.1.1, “Overview of Numeric Types”

/

Section 11.5.1, “Arithmetic Operators”
Section 18.5, “Restrictions and Limitations on Partitioning”
Section 5.1.4, “Server System Variables”

<

Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

<<

Section 11.11.1, “Bit Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 18.5, “Restrictions and Limitations on Partitioning”

<=

Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

<=>

Section 11.2.3, “Comparison Functions and Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”
Section 11.2.2, “Type Conversion in Expression Evaluation”

<>

Section 11.2.3, “Comparison Functions and Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

=

Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section D.3, “Restrictions on Subqueries”
Section 11.4.1, “String Comparison Functions”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

>

Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

>=

Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

>>

Section 11.11.1, “Bit Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 18.5, “Restrictions and Limitations on Partitioning”

AND

Section 12.1.17, “CREATE TABLE Syntax”
Section 7.4.4, “How MySQL Uses Indexes”
Section 7.2.6, “Index Merge Optimization”
Section 11.2.4, “Logical Operators”
Section 1.5, “What Is New in MySQL 5.1”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.16, “Optimizing IN/=ANY Subqueries”
Section D.3, “Restrictions on Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 11.4.1, “String Comparison Functions”
Section 7.2.6.1, “The Index Merge Intersection Access Algorithm”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”
Section 19.5.2, “View Processing Algorithms”

BETWEEN

Section 11.2.3, “Comparison Functions and Operators”
Section 7.4.4, “How MySQL Uses Indexes”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

BINARY

Section B.5.5.1, “Case Sensitivity in String Searches”
Section 11.9, “Cast Functions and Operators”
Section 11.11.2, “Encryption and Compression Functions”
Section 3.3.4.7, “Pattern Matching”
Section 3.3.4.4, “Sorting Rows”
Section 9.1.7.3, “The BINARY Operator”

BINARY str

Section 11.9, “Cast Functions and Operators”

CASE

Section 11.3, “Control Flow Functions”
Section 1.8.4, “MySQL Extensions to Standard SQL”

CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END

Section 11.3, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 11.3, “Control Flow Functions”

CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END

Section 11.3, “Control Flow Functions”

DIV

Section 11.5.1, “Arithmetic Operators”
Section 18.5, “Restrictions and Limitations on Partitioning”

IS NOT NULL

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

IS NOT boolean_value

Section 11.2.3, “Comparison Functions and Operators”

IS NULL

Section 7.2.8, “IS NULL Optimization”
Section 11.2.3, “Comparison Functions and Operators”
Section 7.2.16, “Optimizing IN/=ANY Subqueries”
Section 7.2.1, “Optimizing Queries with EXPLAIN”
Section B.5.5.3, “Problems with NULL Values”
Section 5.1.5, “Session System Variables”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

IS boolean_value

Section 11.2.3, “Comparison Functions and Operators”

LIKE

Section 12.4.5.4, “SHOW CHARACTER SET Syntax”
Section 12.4.5.5, “SHOW COLLATION Syntax”
Section 12.4.5.6, “SHOW COLUMNS Syntax”
Section 12.4.5.15, “SHOW DATABASES Syntax”
Section 12.4.5.19, “SHOW EVENTS Syntax”
Section 12.4.5.23, “SHOW INDEX Syntax”
Section 12.4.5.26, “SHOW OPEN TABLES Syntax”
Section 12.4.5.30, “SHOW PROCEDURE STATUS Syntax”
Section 12.4.5.37, “SHOW STATUS Syntax”
Section 12.4.5.38, “SHOW TABLE STATUS Syntax”
Section 12.4.5.39, “SHOW TABLES Syntax”
Section 12.4.5.40, “SHOW TRIGGERS Syntax”
Section 12.4.5.41, “SHOW VARIABLES Syntax”
Section 9.1.9.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 5.4.5, “Access Control, Stage 2: Request Verification”
Section 11.9, “Cast Functions and Operators”
Section 20.28, “Extensions to SHOW Statements”
Section 7.4.4, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 3.3.4.7, “Pattern Matching”
Section 17.5.7, “Quick Reference: MySQL Cluster SQL Statements”
Section 16.1.3.3, “Replication Slave Options and Variables”
Section 5.4.3, “Specifying Account Names”
Section 11.4.1, “String Comparison Functions”
Section 8.1.1, “Strings”
Section 5.1.6.1, “Structured System Variables”
Section 10.4.5, “The SET Type”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”
Section 5.1.6, “Using System Variables”

LIKE 'pattern'

Section 12.4.5, “SHOW Syntax”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”

LIKE ... ESCAPE

Section B.5.8.2, “Additional Known Issues”
Section B.5.8.1, “Open Issues in MySQL”

N % M

Section 11.5.1, “Arithmetic Operators”
Section 11.5.2, “Mathematical Functions”

N MOD M

Section 11.5.2, “Mathematical Functions”

NOT

Section 11.2.4, “Logical Operators”
Section 11.2.1, “Operator Precedence”
Section 5.1.8, “Server SQL Modes”

NOT LIKE

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

NOT REGEXP

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 3.3.4.7, “Pattern Matching”
Section 11.4.1, “String Comparison Functions”

NOT RLIKE

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

OR

Section 12.4.1.3, “GRANT Syntax”
Section 7.2.6, “Index Merge Optimization”
Section 11.2.4, “Logical Operators”
Section 1.5, “What Is New in MySQL 5.1”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.2.16, “Optimizing IN/=ANY Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 5.1.8, “Server SQL Modes”
Section 11.4.1, “String Comparison Functions”
Section 7.2.6.3, “The Index Merge Sort-Union Access Algorithm”
Section 7.2.6.2, “The Index Merge Union Access Algorithm”
Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”

REGEXP

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section D.6, “Restrictions on Character Sets”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.4.2, “Regular Expressions”
Section D.6, “Restrictions on Character Sets”

XOR

Section 11.12.1, “GROUP BY (Aggregate) Functions”
Section 11.2.4, “Logical Operators”

^

Section 11.11.1, “Bit Functions”
Section 11.2.1, “Operator Precedence”
Section 18.5, “Restrictions and Limitations on Partitioning”

expr BETWEEN min AND max

Section 11.2.3, “Comparison Functions and Operators”

expr LIKE pat [ESCAPE 'escape_char']

Section 11.4.1, “String Comparison Functions”

expr NOT BETWEEN min AND max

Section 11.2.3, “Comparison Functions and Operators”

expr NOT LIKE pat [ESCAPE 'escape_char']

Section 11.4.1, “String Comparison Functions”

expr NOT REGEXP pat

Section 11.4.2, “Regular Expressions”

expr NOT RLIKE pat

Section 11.4.2, “Regular Expressions”

expr REGEXP pat

Section 11.4.2, “Regular Expressions”

expr RLIKE pat

Section 11.4.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 11.4, “String Functions”

|

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”

||

Section 9.1.7.2, “COLLATE Clause Precedence”
Section 11.2.4, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.2.1, “Operator Precedence”
Section 9.1.9.1, “Result Strings”
Section 12.2.9.11, “Rewriting Subqueries as Joins”
Section 5.1.8, “Server SQL Modes”

~

Section 11.11.1, “Bit Functions”
Section 18.5, “Restrictions and Limitations on Partitioning”