SQL explained: What is SQL | Select Statement | Select Where | Insert | Update/Edit | Delete | Order By | Select Between

SQL Select Where

Using the Where clause will let you be more specific with our criteria for selecting records.

Syntax:Select * From Tablename WHERE ColumnName='Value1'

If we wanted to select all the records from our table 'Members_tbl' in Diagram 1 below where Lastname was equal to Wall we could use the following SQL statement with the Where clause.

Select * From Members_tbl WHERE LastName='Wall'

Diagram 1

Diagram 2 shows the results that our SQL statement would return.

Diagram 2