Learn SQLite in Neovim: LIKE & Pattern Matching — Wildcards % and _ | Episode 9

Stop searching for exact matches only! LIKE lets you search for patterns with wildcards — starts with, ends with,
contains, and more.

We build a cities database with 10 American cities and use LIKE with percent and underscore wildcards to find
patterns in city names.

Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode09

Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace.

What You'll Learn:
- LIKE for pattern matching in WHERE clauses
- % wildcard — matches any number of characters
- Starts with ('San%'), ends with ('%ville'), contains ('%land%')
- _ wildcard — matches exactly one character
- NOT LIKE to exclude matching patterns
- Running SQL files with :!sqlite3 :memory

Timestamps:
0:00 - Introduction
0:12 - Preview: What We Cover
0:44 - Creating like.sql
1:49 - CREATE TABLE cities (10 cities)
3:05 - INSERT — ten American cities
5:11 - SELECT * — all ten cities
5:44 - LIKE 'San%' — starts with San
6:20 - LIKE 'New%' — starts with New
6:57 - LIKE '%ville' — ends with ville
7:33 - LIKE '%land%' — contains land
8:10 - LIKE '_a%' — second letter is a
8:47 - NOT LIKE 'San%' — exclude San cities
9:25 - Recap: 3 Key Takeaways
10:00 - End Screen

Key Takeaways:
1. % matches any number of characters — starts with, ends with, or contains
2. _ matches exactly one character — position-based patterns
3. NOT LIKE excludes matching rows — combine with any pattern

This is Episode 9 of the Learn SQLite in Neovim series — 32 episodes from beginner to advanced.

Taught by CelesteAI. Like & subscribe for more tutorials!

#sqlite #sql #neovim #programming #tutorial #beginners #learnsql #database #like #wildcards #patternmatching
#sqlitetutorial #coding

Tags

sqlite, sqlite tutorial, learn sqlite, sql tutorial, sql for beginners, neovim sqlite, like sql, wildcards sql,
pattern matching, percent underscore, neovim tutorial, learn sql in neovim, sql basics, sqlite episode 9,
programming tutorial, coding tutorial, beginner programming, sqlite 2026, neovim 2026, screenkey, code along,
database tutorial

Видео Learn SQLite in Neovim: LIKE & Pattern Matching — Wildcards % and _ | Episode 9 канала Codegiz — Built by Claude AI