Learn SQLite in Neovim: WHERE Clause — Filter Your Data | Episode 5

Stop getting every row! The WHERE clause lets you filter data and find exactly what you need. We build a music library with 8 classic and modern songs, then use WHERE with six comparison operators to filter by year, duration, and artist. Student code: https://github.com/GoCelesteAI/learn-sqlite-in-neovim/tree/main/episode05 Every keystroke is shown on screen with 3-second pauses so you can follow along at your own pace. What You'll Learn: - WHERE clause to filter rows after SELECT - Equals (=) for exact matches — numbers and text - Greater than and less than for ranges - Not equal (!=) to exclude values - Filtering TEXT columns with single quotes - Running SQL files with :!sqlite3 :memory Timestamps: 0:00 - Introduction 0:12 - Preview: What We Cover 0:44 - Creating where.sql 1:50 - CREATE TABLE songs (music library) 3:07 - INSERT — eight classic and modern songs 5:04 - SELECT * — all eight songs 5:37 - WHERE year = 2019 (equals) 6:13 - WHERE year gt 2000 (greater than) 6:50 - WHERE duration gt 300 (long songs) 7:27 - WHERE artist = 'Queen' (text match) 8:03 - WHERE duration lt 210 (short songs) 8:40 - WHERE year != 2019 (not equal) 9:13 - Recap: 3 Key Takeaways 9:48 - End Screen Key Takeaways: 1. WHERE filters rows — add it after FROM to set your condition 2. Six operators 3. WHERE works with both numbers and text — text values go in single quotes This is Episode 5 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 #where #filter #sqlitetutorial #coding Tags sqlite, sqlite tutorial, learn sqlite, sql tutorial, sql for beginners, neovim sqlite, where clause sql, sql filter, comparison operators, neovim tutorial, learn sql in neovim, sql basics, sqlite episode 5, programming tutorial, coding tutorial, beginner programming, sqlite 2026, neovim 2026, screenkey, code along, database tutorial