Our table is pretty small, so if we wanted to get some information about Volkswagens, we could select all rows and just ignore the extra few that contain other brands. But what if our table consisted of thousands of rows? In that case, we couldn't possibly go through all the results trying to find the rows that we want to look at. Instead, we can filter the results like so:
WHERE Id = 100;
Look what happened – we've added the
WHERE keyword and a condition. The simplest is an equality. In our case, we want to retrieve information about a user with a specific ID (100), so we use an equality (
Id = 100).