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 19.5.2, “View Processing Algorithms”
- Section 1.5, “What Is New in MySQL 5.1”
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.10, “Cast Functions and Operators”
- Section 20.28, “Extensions to
SHOW
Statements” - Section 7.5.3, “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.5.1, “String Comparison Functions”
- Section 8.1.1, “Strings”
- Section 5.1.5.1, “Structured System Variables”
- Section 10.4.5, “The
SET
Type” - Section 7.3.1.3.1, “The Range Access Method for Single-Part Indexes”
- Section 5.1.5, “Using System Variables”
OR
- Section 12.4.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.7, “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.5, “What Is New in MySQL 5.1”