You can use a LIKE clause as the condition in a WHERE clause to select records where a string fits a specified pattern. List the name of the column (e.g., city) after WHERE, then a LIKE clause describing the text pattern to search for (e.g., ‘S % o__’).