Find rows by pattern.
Section: Read and filter rows
Filter with WHERE and LIKE
sql
sql
SELECT id, title FROM posts WHERE title LIKE '%sqlite%';Explanation
LIKE is convenient for simple matching; full-text search is better for larger text search needs.
Learn the surrounding workflow
Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.
Related commands
Same sheet · prioritizing Read and filter rows