Is there a way to only `SELECT` rows with certain data in a column, without using `WHERE`?

e.g. If I had this:

```
SELECT * FROM Users
WHERE town = 'Townsville'

```

is there a way to implement the `WHERE` clause into the `SELECT` statement?

something like

```
SELECT *, town('Townsville') FROM Users

```

It's a bizarre question but it's one I've been asked by my peers