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'.