The WHERE clause is used to filter data that is returned by the SELECT statement.

Syntax

SELECT [ ALL | DISTINCT ]
{ * | projectItem [, projectItem ]* }
FROM tableExpression
[ WHERE booleanExpression ];

Example

  • Test data
    Address City
    Oxford Street Beijing
    Fifth Avenue Beijing
    Changan Street shanghai
  • Statement 
    SELECT * FROM XXXX WHERE City='Beijing';
  • Result
    Address City
    Oxford Street Beijing
    Fifth Avenue Beijing