LIKE in SQL, Explained for Beginners

Beginner guide to SQL LIKE: what the % and _ wildcards do, how moving the wildcard changes the question, case sensitivity by database, the over-matching trap, NOT LIKE, escaping a literal percent sign, and why LIKE '%text%' gets slow.