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