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

Operator Index

!

Section 8.5, “Expression Syntax”
Section 11.3.3, “Logical Operators”
Section 11.3.1, “Operator Precedence”

!=

Section 11.3.2, “Comparison Functions and Operators”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

%

Section 11.6.1, “Arithmetic Operators”

&

Section 12.1.17, “CREATE TABLE Syntax”
Section 11.12, “Bit Functions”
Section 17.5, “Restrictions and Limitations on Partitioning”

&&

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

*

Section 11.6.1, “Arithmetic Operators”
Section 10.1.1, “Numeric Type Overview”
Section 17.5, “Restrictions and Limitations on Partitioning”

+

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 11.7, “Date and Time Functions”
Section 10.1.1, “Numeric Type Overview”
Section 17.5, “Restrictions and Limitations on Partitioning”

-

Section 11.6.1, “Arithmetic Operators”
Section 11.10, “Cast Functions and Operators”
Section 11.7, “Date and Time Functions”
Section 10.1.1, “Numeric Type Overview”
Section 17.5, “Restrictions and Limitations on Partitioning”

/

Section 11.6.1, “Arithmetic Operators”
Section 17.5, “Restrictions and Limitations on Partitioning”
Section 5.1.3, “Server System Variables”

<

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.5.3, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

<<

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

<=

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.5.3, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

<=>

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 11.2, “Type Conversion in Expression Evaluation”

<>

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

=

Section 7.2.2, “EXPLAIN Output Format”
Section 12.7.4, “SET Syntax”
Section 11.3.4, “Assignment Operators”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.5.3, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section E.3, “Restrictions on Subqueries”
Section 11.5.1, “String Comparison Functions”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 8.4, “User-Defined Variables”
Section 3.3.4.6, “Working with NULL Values”

>

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.5.3, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

>=

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.5.3, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

>>

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

AND

Section 12.1.17, “CREATE TABLE Syntax”
Section 7.5.3, “How MySQL Uses Indexes”
Section 7.3.1.4, “Index Merge Optimization”
Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 7.3.1.14, “Optimizing IN/=ANY Subqueries”
Section E.3, “Restrictions on Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 11.5.1, “String Comparison Functions”
Section 7.3.1.4.1, “The Index Merge Intersection Access Algorithm”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 18.5.2, “View Processing Algorithms”
Section 1.4, “What Is New in MySQL 5.1”

BETWEEN

Section 7.2.2, “EXPLAIN Output Format”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.5.3, “How MySQL Uses Indexes”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 11.2, “Type Conversion in Expression Evaluation”

BINARY

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

BINARY str

Section 11.10, “Cast Functions and Operators”

CASE

Section 12.6.5.1, “CASE Syntax”
Section 11.4, “Control Flow Functions”
Section 8.5, “Expression Syntax”
Section 1.8.4, “MySQL Extensions to Standard SQL”

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

Section 11.4, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 11.4, “Control Flow Functions”

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

Section 11.4, “Control Flow Functions”

DIV

Section 11.6.1, “Arithmetic Operators”
Section 17.5, “Restrictions and Limitations on Partitioning”

IS

Section 11.3.1, “Operator Precedence”

IS NOT NULL

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

IS NOT boolean_value

Section 11.3.2, “Comparison Functions and Operators”

IS NULL

Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.6, “IS NULL Optimization”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.3.1.14, “Optimizing IN/=ANY Subqueries”
Section C.5.5.3, “Problems with NULL Values”
Section 5.1.3, “Server System Variables”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 3.3.4.6, “Working with NULL Values”

IS boolean_value

Section 11.3.2, “Comparison Functions and Operators”

LIKE

Section 12.7.5.4, “SHOW CHARACTER SET Syntax”
Section 12.7.5.5, “SHOW COLLATION Syntax”
Section 12.7.5.6, “SHOW COLUMNS Syntax”
Section 12.7.5.15, “SHOW DATABASES Syntax”
Section 12.7.5.19, “SHOW EVENTS Syntax”
Section 12.7.5.26, “SHOW OPEN TABLES Syntax”
Section 12.7.5.30, “SHOW PROCEDURE STATUS Syntax”
Section 12.7.5.37, “SHOW STATUS Syntax”
Section 12.7.5.38, “SHOW TABLE STATUS Syntax”
Section 12.7.5.39, “SHOW TABLES Syntax”
Section 12.7.5.40, “SHOW TRIGGERS Syntax”
Section 12.7.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.10, “Cast Functions and Operators”
Section 19.28, “Extensions to SHOW Statements”
Section 7.5.3, “How MySQL Uses Indexes”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 16.5.8, “Quick Reference: MySQL Cluster SQL Statements”
Section 15.1.3.3, “Replication Slave Options and Variables”
Section 5.4.3, “Specifying Account Names”
Section 11.5.1, “String Comparison Functions”
Section 8.1.1, “String Literals”
Section 5.1.4.1, “Structured System Variables”
Section 10.4.5, “The SET Type”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 5.1.4, “Using System Variables”

LIKE 'pattern'

Section 12.7.5, “SHOW Syntax”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”

LIKE ... ESCAPE

Section C.5.8, “Known Issues in MySQL”

N % M

Section 11.6.1, “Arithmetic Operators”
Section 11.6.2, “Mathematical Functions”

N MOD M

Section 11.6.1, “Arithmetic Operators”
Section 11.6.2, “Mathematical Functions”

NOT

Section 11.3.3, “Logical Operators”
Section 5.1.6, “Server SQL Modes”

NOT LIKE

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

NOT REGEXP

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

NOT RLIKE

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

OR

Section 12.7.1.3, “GRANT Syntax”
Section 8.5, “Expression Syntax”
Section 7.3.1.4, “Index Merge Optimization”
Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 7.3.1.14, “Optimizing IN/=ANY Subqueries”
Section 3.6.7, “Searching on Two Keys”
Section 3.3.4.2, “Selecting Particular Rows”
Section 5.1.6, “Server SQL Modes”
Section 11.5.1, “String Comparison Functions”
Section 7.3.1.4.3, “The Index Merge Sort-Union Access Algorithm”
Section 7.3.1.4.2, “The Index Merge Union Access Algorithm”
Section 7.3.1.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 1.4, “What Is New in MySQL 5.1”

REGEXP

Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section E.6, “Restrictions on Character Sets”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section E.6, “Restrictions on Character Sets”

XOR

Section 11.16.1, “GROUP BY (Aggregate) Functions”
Section 11.3.3, “Logical Operators”

^

Section 11.12, “Bit Functions”
Section 8.5, “Expression Syntax”
Section 11.3.1, “Operator Precedence”
Section 17.5, “Restrictions and Limitations on Partitioning”

expr BETWEEN min AND max

Section 11.3.2, “Comparison Functions and Operators”

expr LIKE pat [ESCAPE 'escape_char']

Section 11.5.1, “String Comparison Functions”

expr NOT BETWEEN min AND max

Section 11.3.2, “Comparison Functions and Operators”

expr NOT LIKE pat [ESCAPE 'escape_char']

Section 11.5.1, “String Comparison Functions”

expr NOT REGEXP pat

Section 11.5.2, “Regular Expressions”

expr NOT RLIKE pat

Section 11.5.2, “Regular Expressions”

expr REGEXP pat

Section 11.5.2, “Regular Expressions”

expr RLIKE pat

Section 11.5.2, “Regular Expressions”

expr1 SOUNDS LIKE expr2

Section 11.5, “String Functions”

|

Section 11.12, “Bit Functions”
Section 17.5, “Restrictions and Limitations on Partitioning”

||

Section 9.1.7.3, “COLLATE Clause Precedence”
Section 8.5, “Expression Syntax”
Section 11.3.3, “Logical Operators”
Section 1.8.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 9.1.9.1, “Result Strings”
Section 5.1.6, “Server SQL Modes”

~

Section 11.12, “Bit Functions”
Section 17.5, “Restrictions and Limitations on Partitioning”
Copyright © 1997, 2012, Oracle and/or its affiliates. All rights reserved. Legal Notices