<html><head><meta http-equiv="Content-Type" content="text/html; charset=utf-8"><title>Operator Index</title><link rel="stylesheet" href="mysql-html.css" type="text/css"><meta name="generator" content="DocBook XSL Stylesheets V1.69.1"><link rel="start" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="up" href="index.html" title="MySQL 5.1 Reference Manual"><link rel="prev" href="dynindex-jointype.html" title="JOIN Types Index"><link rel="next" href="dynindex-option.html" title="Option Index"></head><body bgcolor="white" text="black" link="#0000FF" vlink="#840084" alink="#0000FF"><div class="navheader"><table width="100%" summary="Navigation header"><tr><th colspan="3" align="center">Operator Index</th></tr><tr><td width="20%" align="left"><a accesskey="p" href="dynindex-jointype.html">Prev</a> </td><th width="60%" align="center"> </th><td width="20%" align="right"> <a accesskey="n" href="dynindex-option.html">Next</a></td></tr></table><hr></div><div class="index"><div class="titlepage"><div><div><h2 class="title"><a name="dynindex-operator"></a>Operator Index</h2></div></div></div><div class="indexdiv"><h3 class="title"><code class="literal">!</code></h3><dl><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt><dt><a href="functions.html#operator-precedence" title="11.2.1. Operator Precedence">Section 11.2.1, “Operator Precedence”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">!=</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">%</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">&</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">&&</code></h3><dl><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">*</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="data-types.html#numeric-type-overview" title="10.1.1. Overview of Numeric Types">Section 10.1.1, “Overview of Numeric Types”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">+</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="data-types.html#numeric-type-overview" title="10.1.1. Overview of Numeric Types">Section 10.1.1, “Overview of Numeric Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">-</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt><dt><a href="functions.html#date-and-time-functions" title="11.6. Date and Time Functions">Section 11.6, “Date and Time Functions”</a></dt><dt><a href="data-types.html#numeric-type-overview" title="10.1.1. Overview of Numeric Types">Section 10.1.1, “Overview of Numeric Types”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">/</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt><dt><a href="server-administration.html#server-system-variables" title="5.1.4. Server System Variables">Section 5.1.4, “Server System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal"><</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal"><<</code></h3><dl><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal"><=</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal"><=></code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt><dt><a href="functions.html#type-conversion" title="11.2.2. Type Conversion in Expression Evaluation">Section 11.2.2, “Type Conversion in Expression Evaluation”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal"><></code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">=</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="restrictions.html#subquery-restrictions" title="D.3. Restrictions on Subqueries">Section D.3, “Restrictions on Subqueries”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">></code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">>=</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">>></code></h3><dl><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">AND</code></h3><dl><dt><a href="sql-syntax.html#create-table" title="12.1.17. CREATE TABLE Syntax">Section 12.1.17, “<code class="literal">CREATE TABLE</code> Syntax”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="optimization.html#index-merge-optimization" title="7.2.6. Index Merge Optimization">Section 7.2.6, “Index Merge Optimization”</a></dt><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="restrictions.html#subquery-restrictions" title="D.3. Restrictions on Subqueries">Section D.3, “Restrictions on Subqueries”</a></dt><dt><a href="tutorial.html#searching-on-two-keys" title="3.6.7. Searching on Two Keys">Section 3.6.7, “Searching on Two Keys”</a></dt><dt><a href="tutorial.html#selecting-rows" title="3.3.4.2. Selecting Particular Rows">Section 3.3.4.2, “Selecting Particular Rows”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt><dt><a href="optimization.html#index-merge-intersection" title="7.2.6.1. The Index Merge Intersection Access Algorithm">Section 7.2.6.1, “The Index Merge Intersection Access Algorithm”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt><dt><a href="stored-programs-views.html#view-algorithms" title="19.5.2. View Processing Algorithms">Section 19.5.2, “View Processing Algorithms”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BETWEEN</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BINARY</code></h3><dl><dt><a href="internationalization-localization.html#charset-binary-op" title="9.1.7.3. BINARY Operator">Section 9.1.7.3, “<code class="literal">BINARY</code> Operator”</a></dt><dt><a href="error-handling.html#case-sensitivity" title="B.1.5.1. Case Sensitivity in String Searches">Section B.1.5.1, “Case Sensitivity in String Searches”</a></dt><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt><dt><a href="functions.html#encryption-functions" title="11.11.2. Encryption and Compression Functions">Section 11.11.2, “Encryption and Compression Functions”</a></dt><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="tutorial.html#sorting-rows" title="3.3.4.4. Sorting Rows">Section 3.3.4.4, “Sorting Rows”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">BINARY str</code></h3><dl><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CASE</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CASE WHEN [condition] THEN result [WHEN [condition] THEN result ...] [ELSE result] END</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CASE WHEN expr1 = expr2 THEN NULL ELSE expr1 END</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">CASE value WHEN [compare_value] THEN result [WHEN [compare_value] THEN result ...] [ELSE result] END</code></h3><dl><dt><a href="functions.html#control-flow-functions" title="11.3. Control Flow Functions">Section 11.3, “Control Flow Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">DIV</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS NOT NULL</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt><dt><a href="tutorial.html#working-with-null" title="3.3.4.6. Working with NULL Values">Section 3.3.4.6, “Working with <code class="literal">NULL</code> Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS NOT boolean_value</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS NULL</code></h3><dl><dt><a href="optimization.html#is-null-optimization" title="7.2.8. IS NULL Optimization">Section 7.2.8, “<code class="literal">IS NULL</code> Optimization”</a></dt><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="optimization.html#using-explain" title="7.2.1. Optimizing Queries with EXPLAIN">Section 7.2.1, “Optimizing Queries with <code class="literal">EXPLAIN</code>”</a></dt><dt><a href="error-handling.html#problems-with-null" title="B.1.5.3. Problems with NULL Values">Section B.1.5.3, “Problems with <code class="literal">NULL</code> Values”</a></dt><dt><a href="server-administration.html#server-session-variables" title="5.1.5. Session System Variables">Section 5.1.5, “Session System Variables”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt><dt><a href="tutorial.html#working-with-null" title="3.3.4.6. Working with NULL Values">Section 3.3.4.6, “Working with <code class="literal">NULL</code> Values”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">IS boolean_value</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LIKE</code></h3><dl><dt><a href="sql-syntax.html#show-character-set" title="12.5.5.4. SHOW CHARACTER SET Syntax">Section 12.5.5.4, “<code class="literal">SHOW CHARACTER SET</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-collation" title="12.5.5.5. SHOW COLLATION Syntax">Section 12.5.5.5, “<code class="literal">SHOW COLLATION</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-columns" title="12.5.5.6. SHOW COLUMNS Syntax">Section 12.5.5.6, “<code class="literal">SHOW COLUMNS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-databases" title="12.5.5.15. SHOW DATABASES Syntax">Section 12.5.5.15, “<code class="literal">SHOW DATABASES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-events" title="12.5.5.19. SHOW EVENTS Syntax">Section 12.5.5.19, “<code class="literal">SHOW EVENTS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-index" title="12.5.5.23. SHOW INDEX Syntax">Section 12.5.5.23, “<code class="literal">SHOW INDEX</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-open-tables" title="12.5.5.26. SHOW OPEN TABLES Syntax">Section 12.5.5.26, “<code class="literal">SHOW OPEN TABLES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-procedure-status" title="12.5.5.30. SHOW PROCEDURE STATUS Syntax">Section 12.5.5.30, “<code class="literal">SHOW PROCEDURE STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-status" title="12.5.5.37. SHOW STATUS Syntax">Section 12.5.5.37, “<code class="literal">SHOW STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-table-status" title="12.5.5.38. SHOW TABLE STATUS Syntax">Section 12.5.5.38, “<code class="literal">SHOW TABLE STATUS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-tables" title="12.5.5.39. SHOW TABLES Syntax">Section 12.5.5.39, “<code class="literal">SHOW TABLES</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-triggers" title="12.5.5.40. SHOW TRIGGERS Syntax">Section 12.5.5.40, “<code class="literal">SHOW TRIGGERS</code> Syntax”</a></dt><dt><a href="sql-syntax.html#show-variables" title="12.5.5.41. SHOW VARIABLES Syntax">Section 12.5.5.41, “<code class="literal">SHOW VARIABLES</code> Syntax”</a></dt><dt><a href="internationalization-localization.html#charset-show" title="9.1.9.3. SHOW Statements and
INFORMATION_SCHEMA">Section 9.1.9.3, “<code class="literal">SHOW</code> Statements and
<code class="literal">INFORMATION_SCHEMA</code>”</a></dt><dt><a href="server-administration.html#request-access" title="5.4.5. Access Control, Stage 2: Request Verification">Section 5.4.5, “Access Control, Stage 2: Request Verification”</a></dt><dt><a href="functions.html#cast-functions" title="11.9. Cast Functions and Operators">Section 11.9, “Cast Functions and Operators”</a></dt><dt><a href="information-schema.html#extended-show" title="20.28. Extensions to SHOW Statements">Section 20.28, “Extensions to <code class="literal">SHOW</code> Statements”</a></dt><dt><a href="optimization.html#mysql-indexes" title="7.4.4. How MySQL Uses Indexes">Section 7.4.4, “How MySQL Uses Indexes”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="mysql-cluster.html#mysql-cluster-sql-statements" title="17.5.7. Quick Reference: MySQL Cluster SQL Statements">Section 17.5.7, “Quick Reference: MySQL Cluster SQL Statements”</a></dt><dt><a href="replication.html#replication-options-slave" title="16.1.3.3. Replication Slave Options and Variables">Section 16.1.3.3, “Replication Slave Options and Variables”</a></dt><dt><a href="server-administration.html#account-names" title="5.4.3. Specifying Account Names">Section 5.4.3, “Specifying Account Names”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt><dt><a href="language-structure.html#string-syntax" title="8.1.1. Strings">Section 8.1.1, “Strings”</a></dt><dt><a href="server-administration.html#structured-system-variables" title="5.1.6.1. Structured System Variables">Section 5.1.6.1, “Structured System Variables”</a></dt><dt><a href="data-types.html#set" title="10.4.5. The SET Type">Section 10.4.5, “The <code class="literal">SET</code> Type”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt><dt><a href="server-administration.html#using-system-variables" title="5.1.6. Using System Variables">Section 5.1.6, “Using System Variables”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LIKE 'pattern'</code></h3><dl><dt><a href="sql-syntax.html#show" title="12.5.5. SHOW Syntax">Section 12.5.5, “<code class="literal">SHOW</code> Syntax”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">LIKE ... ESCAPE</code></h3><dl><dt><a href="error-handling.html#open-bugs-general" title="B.1.8.2. Additional Known Issues">Section B.1.8.2, “Additional Known Issues”</a></dt><dt><a href="error-handling.html#open-bugs" title="B.1.8.1. Open Issues in MySQL">Section B.1.8.1, “Open Issues in MySQL”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">N % M</code></h3><dl><dt><a href="functions.html#arithmetic-functions" title="11.5.1. Arithmetic Operators">Section 11.5.1, “Arithmetic Operators”</a></dt><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">N MOD M</code></h3><dl><dt><a href="functions.html#mathematical-functions" title="11.5.2. Mathematical Functions">Section 11.5.2, “Mathematical Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NOT</code></h3><dl><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt><dt><a href="functions.html#operator-precedence" title="11.2.1. Operator Precedence">Section 11.2.1, “Operator Precedence”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NOT LIKE</code></h3><dl><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NOT REGEXP</code></h3><dl><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">NOT RLIKE</code></h3><dl><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">OR</code></h3><dl><dt><a href="sql-syntax.html#grant" title="12.5.1.3. GRANT Syntax">Section 12.5.1.3, “<code class="literal">GRANT</code> Syntax”</a></dt><dt><a href="optimization.html#index-merge-optimization" title="7.2.6. Index Merge Optimization">Section 7.2.6, “Index Merge Optimization”</a></dt><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt><dt><a href="introduction.html#mysql-nutshell" title="1.4.1. What Is New in MySQL 5.1">Section 1.4.1, “What Is New in MySQL 5.1”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="optimization.html#in-subquery-optimization" title="7.2.16. Optimizing IN/=ANY Subqueries">Section 7.2.16, “Optimizing <code class="literal">IN</code>/<code class="literal">=ANY</code> Subqueries”</a></dt><dt><a href="tutorial.html#searching-on-two-keys" title="3.6.7. Searching on Two Keys">Section 3.6.7, “Searching on Two Keys”</a></dt><dt><a href="tutorial.html#selecting-rows" title="3.3.4.2. Selecting Particular Rows">Section 3.3.4.2, “Selecting Particular Rows”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt><dt><a href="optimization.html#index-merge-sort-union" title="7.2.6.3. The Index Merge Sort-Union Access Algorithm">Section 7.2.6.3, “The Index Merge Sort-Union Access Algorithm”</a></dt><dt><a href="optimization.html#index-merge-union" title="7.2.6.2. The Index Merge Union Access Algorithm">Section 7.2.6.2, “The Index Merge Union Access Algorithm”</a></dt><dt><a href="optimization.html#range-access-multi-part" title="7.2.5.2. The Range Access Method for Multiple-Part Indexes">Section 7.2.5.2, “The Range Access Method for Multiple-Part Indexes”</a></dt><dt><a href="optimization.html#range-access-single-part" title="7.2.5.1. The Range Access Method for Single-Part Indexes">Section 7.2.5.1, “The Range Access Method for Single-Part Indexes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">REGEXP</code></h3><dl><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="functions.html#regexp" title="11.4.2. Regular Expressions">Section 11.4.2, “Regular Expressions”</a></dt><dt><a href="restrictions.html#charset-restrictions" title="D.6. Restrictions on Character Sets">Section D.6, “Restrictions on Character Sets”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">RLIKE</code></h3><dl><dt><a href="tutorial.html#pattern-matching" title="3.3.4.7. Pattern Matching">Section 3.3.4.7, “Pattern Matching”</a></dt><dt><a href="functions.html#regexp" title="11.4.2. Regular Expressions">Section 11.4.2, “Regular Expressions”</a></dt><dt><a href="restrictions.html#charset-restrictions" title="D.6. Restrictions on Character Sets">Section D.6, “Restrictions on Character Sets”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">XOR</code></h3><dl><dt><a href="functions.html#group-by-functions" title="11.12.1. GROUP BY (Aggregate) Functions">Section 11.12.1, “<code class="literal">GROUP BY</code> (Aggregate) Functions”</a></dt><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">^</code></h3><dl><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt><dt><a href="functions.html#operator-precedence" title="11.2.1. Operator Precedence">Section 11.2.1, “Operator Precedence”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr BETWEEN min AND max</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr LIKE pat [ESCAPE 'escape_char']</code></h3><dl><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr NOT BETWEEN min AND max</code></h3><dl><dt><a href="functions.html#comparison-operators" title="11.2.3. Comparison Functions and Operators">Section 11.2.3, “Comparison Functions and Operators”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr NOT LIKE pat [ESCAPE 'escape_char']</code></h3><dl><dt><a href="functions.html#string-comparison-functions" title="11.4.1. String Comparison Functions">Section 11.4.1, “String Comparison Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr NOT REGEXP pat</code></h3><dl><dt><a href="functions.html#regexp" title="11.4.2. Regular Expressions">Section 11.4.2, “Regular Expressions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr NOT RLIKE pat</code></h3><dl><dt><a href="functions.html#regexp" title="11.4.2. Regular Expressions">Section 11.4.2, “Regular Expressions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr REGEXP pat</code></h3><dl><dt><a href="functions.html#regexp" title="11.4.2. Regular Expressions">Section 11.4.2, “Regular Expressions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr RLIKE pat</code></h3><dl><dt><a href="functions.html#regexp" title="11.4.2. Regular Expressions">Section 11.4.2, “Regular Expressions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">expr1 SOUNDS LIKE expr2</code></h3><dl><dt><a href="functions.html#string-functions" title="11.4. String Functions">Section 11.4, “String Functions”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">|</code></h3><dl><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">||</code></h3><dl><dt><a href="internationalization-localization.html#charset-collate-precedence" title="9.1.7.2. COLLATE Clause Precedence">Section 9.1.7.2, “<code class="literal">COLLATE</code> Clause Precedence”</a></dt><dt><a href="functions.html#logical-operators" title="11.2.4. Logical Operators">Section 11.2.4, “Logical Operators”</a></dt><dt><a href="introduction.html#extensions-to-ansi" title="1.7.4. MySQL Extensions to Standard SQL">Section 1.7.4, “MySQL Extensions to Standard SQL”</a></dt><dt><a href="functions.html#operator-precedence" title="11.2.1. Operator Precedence">Section 11.2.1, “Operator Precedence”</a></dt><dt><a href="internationalization-localization.html#charset-result" title="9.1.9.1. Result Strings">Section 9.1.9.1, “Result Strings”</a></dt><dt><a href="sql-syntax.html#rewriting-subqueries" title="12.2.9.11. Rewriting Subqueries as Joins">Section 12.2.9.11, “Rewriting Subqueries as Joins”</a></dt><dt><a href="server-administration.html#server-sql-mode" title="5.1.8. Server SQL Modes">Section 5.1.8, “Server SQL Modes”</a></dt></dl></div><div class="indexdiv"><h3 class="title"><code class="literal">~</code></h3><dl><dt><a href="functions.html#bit-functions" title="11.11.1. Bit Functions">Section 11.11.1, “Bit Functions”</a></dt><dt><a href="partitioning.html#partitioning-limitations" title="18.5. Restrictions and Limitations on Partitioning">Section 18.5, “Restrictions and Limitations on Partitioning”</a></dt></dl></div></div><div class="navfooter"><hr><table width="100%" summary="Navigation footer"><tr><td width="40%" align="left"><a accesskey="p" href="dynindex-jointype.html">Prev</a> </td><td width="20%" align="center"> </td><td width="40%" align="right"> <a accesskey="n" href="dynindex-option.html">Next</a></td></tr><tr><td width="40%" align="left" valign="top"><code class="literal">JOIN</code> Types Index </td><td width="20%" align="center"><a accesskey="h" href="index.html">Home</a></td><td width="40%" align="right" valign="top"> Option Index</td></tr></table></div></body></html>
