MySQL - ORDER BY

"users" table:

user_id	name	city	age
1	John Doe	New York	15
2	Jimmy McNulty	Los Angeles	44
2	Andrew Wilkins	Chicago	15
2	Bob Seizmore	New York	16

SELECT * FROM users
ORDER BY name;

Result:

user_id	name	city	age
2	Andrew Wilkins	Chicago	15
2	Bob Seizmore	New York	16
2	Jimmy McNulty	Los Angeles	44
1	John Doe	New York	15

MySQL - OR

"users" table:

user_id	name	city	age
1	John Doe	New York	15
2	Jimmy McNulty	Los Angeles	44
2	Andrew Wilkins	Chicago	15
2	Bob Seizmore	New York	16

SELECT * FROM users
WHERE age<18
AND city='New York'
OR city='Chicago';

Result:

user_id	name	city	age
1	John Doe	New York	15
2	Bob Seizmore	New York	16
2	Andrew Wilkins	Chicago	15

MySQL - AND

"users" table:

user_id	name	city	age
1	John Doe	New York	15
2	Jimmy McNulty	Los Angeles	44
2	Andrew Wilkins	Chicago	15
2	Bob Seizmore	New York	16

SELECT * FROM users
WHERE age<18
AND city='New York';

Result:

user_id	name	city	age
1	John Doe	New York	15
2	Bob Seizmore	New York	16

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

MySQL - INSERT INTO

"users" table:

user_id	user_name

INSERT INTO users (user_id, user_name) 
VALUES("1", "Jimmy McNulty");

Result:

user_id	user_name
1	Jimmy McNulty

MySQL - SELECT

"users" table:

user_id	name
1	John Doe
2	Jimmy McNulty

SELECT name FROM users;

Result:

name
John Doe
Jimmy McNulty