MySQL - WHERE

"users" table:

user_id	name	city	age
1	John Doe	New York	15
2	Jimmy McNulty	Los Angeles	44

SELECT * FROM users
WHERE city='Los Angeles';

Result:

user_id	name	city	age
2	Jimmy McNulty	Los Angeles	44

---

"users" table:

user_id	name	city	age
1	John Doe	New York	15
2	Jimmy McNulty	Los Angeles	44

SELECT name,age FROM users
WHERE age<18;

Result:

name	age
John Doe	15