Another key word we can attach to our select statement is the where clause the WHERE clause allows us
to extract records that meet a certain condition using the selected statement see for example we wanted
to select all the records in our database where the first name was Bob we can do so by using the following
as you query
notice that since our S2 will query is wrapped in double quotes we must enclose our search term in single
quotes now to save the file and refresh and you'll see that it brings back one record because we only
have one record in the database where the first name is Bob.
Now let's try another example see we wanted to display the data in the first name column of the user
with the I.D. for in this case we can modify our C R sequel statement as follows
so select first name from table users where ideas equal to four and if we press refresh it retrieve
the record with the first name Bill because Bill that record has the idea for we change that to eight
Gene has the idea eight.