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