Operator Index

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

Symbols

[index top]

-

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 11.3.3, “Logical Operators”

!=

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 11.11, “Bit Functions”

&&

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

>

Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.4.3, “How MySQL Uses Indexes”
Section 1.9.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.11, “Bit Functions”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section 1.9.4, “MySQL Extensions to Standard SQL”

>=

Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.4.3, “How MySQL Uses Indexes”
Section 1.9.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.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.4.3, “How MySQL Uses Indexes”
Section 1.9.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.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 1.9.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.11, “Bit Functions”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 1.9.4, “MySQL Extensions to Standard SQL”

<=

Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.4.3, “How MySQL Uses Indexes”
Section 1.9.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 C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 1.9.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 11.6.1, “Arithmetic Operators”
Section 10.1.1, “Numeric Type Overview”

+

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 11.6.1, “Arithmetic Operators”

:=

Section 11.3.4, “Assignment Operators”
Section 11.3.1, “Operator Precedence”
Section 12.4.4, “SET Syntax”
Section 8.4, “User-Defined Variables”

=

Section 11.3.4, “Assignment Operators”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.4.3, “How MySQL Uses Indexes”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section D.1, “Restrictions on Subqueries”
Section 12.4.4, “SET Syntax”
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 11.11, “Bit Functions”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 8.5, “Expression Syntax”
Section 11.3.1, “Operator Precedence”

|

Section 11.11, “Bit Functions”
Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”

||

Section 9.1.7.3, “COLLATE Clause Precedence”
Section 8.5, “Expression Syntax”
Section 11.3.3, “Logical Operators”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 9.1.8.1, “Result Strings”
Section 12.2.8.11, “Rewriting Subqueries as Joins for Earlier MySQL Versions”
Section 5.1.6, “Server SQL Modes”

~

Section 11.11, “Bit Functions”
Section C.3.56, “Changes in Release 3.23.5 (20 October 1999)”

A

[index top]

AND

Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section C.2.27, “Changes in Release 4.0.5 (13 November 2002)”
Section 7.4.3, “How MySQL Uses Indexes”
Section 11.3.3, “Logical Operators”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section D.1, “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.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

B

[index top]

BETWEEN

Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.4.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”

BETWEEN ? AND ?

Section C.1.21, “Changes in MySQL 4.1.5 (2004-09-16)”

BINARY

Section B.5.5.1, “Case Sensitivity in String Searches”
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”

C

[index top]

CASE

Section C.1.13, “Changes in MySQL 4.1.13 (2005-07-15)”
Section C.1.7, “Changes in MySQL 4.1.19 (2006-04-29)”
Section C.3.59, “Changes in Release 3.23.2 (09 August 1999)”
Section C.3.58, “Changes in Release 3.23.3 (13 September 1999)”
Section C.3.28, “Changes in Release 3.23.33 (09 February 2001)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section C.2.24, “Changes in Release 4.0.8 (07 January 2003)”
Section 11.4, “Control Flow Functions”
Section 8.5, “Expression Syntax”
Section 1.9.4, “MySQL Extensions to Standard SQL”

CASE value WHEN END

Section 11.4, “Control Flow Functions”

CASE WHEN END

Section 11.4, “Control Flow Functions”

CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END

Section 11.4, “Control Flow Functions”

D

[index top]

DIV

Section 11.6.1, “Arithmetic Operators”

E

[index top]

expr BETWEEN min AND max

Section 11.3.2, “Comparison Functions and Operators”

expr LIKE pat

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

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”

expr SOUNDS LIKE expr

Section C.1.26, “Changes in MySQL 4.1.0 (2003-04-03, Alpha)”

expr1 SOUNDS LIKE expr2

Section 11.5, “String Functions”

I

[index top]

IS

Section 11.3.1, “Operator Precedence”

IS NOT NULL

Section 11.3.2, “Comparison Functions and Operators”
Section B.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 NULL

Section C.1.11, “Changes in MySQL 4.1.15 (2005-10-13)”
Section C.1.3, “Changes in MySQL 4.1.23 (2007-06-12)”
Section C.4.7, “Changes in MySQL/InnoDB-4.0.18, February 13, 2004”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.4, “Changes in Release 3.23.56 (13 March 2003)”
Section C.2.32, “Changes in Release 4.0.0 (October 2001: Alpha)”
Section C.2.21, “Changes in Release 4.0.11 (20 February 2003)”
Section 11.3.2, “Comparison Functions and Operators”
Section 7.2.2, “EXPLAIN Output Format”
Section 7.3.1.4, “IS NULL Optimization”
Section B.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”

L

[index top]

LIKE

Section 5.5.5, “Access Control, Stage 2: Request Verification”
Section 11.10, “Cast Functions and Operators”
Section C.3.61, “Changes in Release 3.23.0 (05 July 1999: Alpha)”
Section C.3.23, “Changes in Release 3.23.37 (17 April 2001)”
Section 7.4.3, “How MySQL Uses Indexes”
Section 1.9.4, “MySQL Extensions to Standard SQL”
Section 11.3.1, “Operator Precedence”
Section 3.3.4.7, “Pattern Matching”
Section 14.8.3, “Replication Slave Options and Variables”
Section 12.4.5.3, “SHOW CHARACTER SET Syntax”
Section 12.4.5.4, “SHOW COLLATION Syntax”
Section 9.1.8.3, “SHOW Statements and INFORMATION_SCHEMA”
Section 12.4.5.22, “SHOW STATUS Syntax”
Section 12.4.5.25, “SHOW VARIABLES Syntax”
Section 5.5.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 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
Section 10.4.5, “The SET Type”
Section 5.1.4, “Using System Variables”
Section 9.2, “Using the German Character Set”

LIKE "%"

Section C.3.57, “Changes in Release 3.23.4 (28 September 1999)”

LIKE "%keyword%"

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”

LIKE "prefix%"

Section C.3.53, “Changes in Release 3.23.8 (02 January 2000)”

LIKE 'abc%'

Section C.4.3, “Changes in MySQL/InnoDB-4.1.3, June 28, 2004”

LIKE 'pattern'

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

LIKE ... ESCAPE

Section B.5.8.4, “Open Issues in MySQL”

N

[index top]

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”

NOT LIKE

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

NOT REGEXP

Section 1.9.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”

O

[index top]

OR

Section C.3.7, “Changes in Release 3.23.53 (09 October 2002)”
Section C.3.1, “Changes in Release 3.23.59 (Not released)”
Section C.2.15, “Changes in Release 4.0.17 (14 December 2003)”
Section C.2.11, “Changes in Release 4.0.21 (06 September 2004)”
Section C.2.7, “Changes in Release 4.0.25 (05 July 2005)”
Section 8.5, “Expression Syntax”
Section 12.4.1.2, “GRANT Syntax”
Section 11.3.3, “Logical Operators”
Section 1.9.4, “MySQL Extensions to Standard SQL”
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.3.2, “The Range Access Method for Multiple-Part Indexes”
Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”

R

[index top]

REGEXP

Section 1.9.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 D.2, “Restrictions on Character Sets”

RLIKE

Section 3.3.4.7, “Pattern Matching”
Section 11.5.2, “Regular Expressions”
Section D.2, “Restrictions on Character Sets”

S

[index top]

SOUNDS LIKE

Section C.1.2, “Changes in MySQL 4.1.24 (2008-03-01)”

X

[index top]

XOR

Section C.2.30, “Changes in Release 4.0.2 (01 July 2002)”
Section 11.15.1, “GROUP BY (Aggregate) Functions”
Section 11.3.3, “Logical Operators”