Section 8.2.1.3, “Index Merge Optimization” Section 12.4.3, “Logical Operators” Section 1.7.1, “MySQL Extensions to Standard SQL” Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy” Section 8.2.1.2, “Range Optimization” Section 13.2.11.12, “Restrictions on Subqueries” Section 8.2.1.22, “Row Constructor Expression Optimization” Section 3.6.7, “Searching on Two Keys” Section 20.3.4.2, “Select Tables” Section 20.4.4.2, “Select Tables” Section 3.3.4.2, “Selecting Particular Rows” Section 12.8.1, “String Comparison Functions and Operators” Section 25.5.2, “View Processing Algorithms” Section 1.3, “What Is New in MySQL 8.0” [index top] Section 12.4.2, “Comparison Functions and Operators” Section 8.3.9, “Comparison of B-Tree and Hash Indexes” Section 8.2.1.13, “Condition Filtering” Section 8.8.2, “EXPLAIN Output Format” Section 8.3.11, “Optimizer Use of Generated Column Indexes” Section 13.5.1, “PREPARE Statement” Section 8.2.1.2, “Range Optimization” Section 11.5, “The JSON Data Type” Section 12.3, “Type Conversion in Expression Evaluation” Section 12.13, “Bit Functions and Operators” Section 12.11, “Cast Functions and Operators” Section 8.4.2.2, “Optimizing for Character and String Types” Section 3.3.4.7, “Pattern Matching” Section 3.3.4.4, “Sorting Rows” [index top] Section 13.6.5.1, “CASE Statement” Section 9.5, “Expressions” Section 12.5, “Flow Control Functions” Section 1.7.1, “MySQL Extensions to Standard SQL” Section 13.5.1, “PREPARE Statement” Section 12.5, “Flow Control Functions” Section 12.5, “Flow Control Functions” CASE WHEN condition THEN result END CASE value WHEN compare_value THEN result END CASE C BINARY BETWEEN B 5743