## expr1 SOUNDS LIKE expr2 

Section 12.8, “String Functions and Operators” 

## I 

[index top] 

## IN() 

Section 8.8.2, “EXPLAIN Output Format” Section 12.4.1, “Operator Precedence” Section 8.3.11, “Optimizer Use of Generated Column Indexes” Section 8.2.1.2, “Range Optimization” Section 8.2.1.22, “Row Constructor Expression Optimization” Section 11.5, “The JSON Data Type” Section 12.3, “Type Conversion in Expression Evaluation” 

## IS 

Section 12.4.1, “Operator Precedence” 

## IS boolean_value 

Section 12.4.2, “Comparison Functions and Operators” 

## IS NOT boolean_value 

Section 12.4.2, “Comparison Functions and Operators” 

## IS NOT NULL 

Section 12.4.2, “Comparison Functions and Operators” Section B.3.4.3, “Problems with NULL Values” Section 8.2.1.2, “Range Optimization” Section 3.3.4.6, “Working with NULL Values” 

## IS NULL 

Section 12.4.2, “Comparison Functions and Operators” Section 8.8.2, “EXPLAIN Output Format” Section 8.2.1.15, “IS NULL Optimization” Section 8.2.2.3, “Optimizing Subqueries with the EXISTS Strategy” Section B.3.4.3, “Problems with NULL Values” Section 8.2.1.2, “Range Optimization” Section 5.1.8, “Server System Variables” Section 3.3.4.6, “Working with NULL Values” 

## L 

[index top] 

## LIKE 

Section 6.2.7, “Access Control, Stage 2: Request Verification” Section 12.11, “Cast Functions and Operators” Section 10.2, “Character Sets and Collations in MySQL” Section 8.3.9, “Comparison of B-Tree and Hash Indexes” Section 8.8.2, “EXPLAIN Output Format” Section 26.8, “Extensions to SHOW Statements” 

