MySQL - WHERE

"users" table:

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

?

1 2	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

?

1 2	SELECT name,age FROM users WHERE age<18;

Result:

name	age
John Doe	15