The WHERE command

The WHERE command is used to specify specific entries to be selected, updated, or deleted:

SELECT * FROM table_name 
    WHERE column_name1= 'Terry Pratchett'

This will SELECT any records where the column_name1 matches 'Terry Pratchett'.

Get Raspberry Pi 3 Cookbook for Python Programmers - Third Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial