#MySQL LIKE子句

-- Matches any sequence of characters

-- Matches zero or more characters

-- Matches exactly one character

-- Multiple underscores

-- Start with, end with

-- Complex patterns

-- Escape wildcards

-- Names starting with A

-- Emails from specific domain

-- Products in category

-- Files with specific extension

-- Users with specific suffix

-- Products containing 'pro'

-- Users with specific pattern

-- Case-insensitive contains

-- Exactly 5 characters

-- Starts with A, ends with Z

-- Contains exactly 3 characters

-- Does not start with

-- Does not contain

-- Does not match pattern

-- Text matching

-- Case sensitivity (MySQL LIKE is case-insensitive by default)

-- Numbers as strings

-- ZIP codes

-- Dates as strings

-- Years

-- Escape % character

-- Escape underscore

-- Use different escape character

-- Complex pattern with escape

-- Update matching patterns

-- Delete matching patterns

-- Not typically used in INSERT, but in SELECT for insert

-- LIKE with leading wildcard cannot use index

-- LIKE without leading wildcard CAN use index

-- Leading wildcard pattern

-- Avoid leading wildcards when possible
-- Instead of: WHERE email LIKE '%@gmail.com'
-- Use: WHERE email REGEXP '@gmail.com$' (still slow, but more flexible)

-- Use FULLTEXT search for large text columns

-- Consider('mysql tutorial storing reverse strings for trailing wildcard

-- LIKE examples

-- REGEXP examples

-- IN for exact matches

-- LIKE for patterns

-- Simple search

-- Search with word boundaries

-- Case-insensitive search

-- Find invalid email patterns

-- Find invalid phone formats

-- Find malformed codes

-- Find duplicate-like entries

-- Find entries with special characters

-- Find empty or whitespace-only