WHERE clause allows you to add condition to your query.
SELECT username
FROM user
WHERE username = param.username Operators
WHERE clause contains a few operators that allow you to make your condition a bit more complex. Below you can find a list of those: