EasyEnv
Engineering/Courses/Catalog/MySQL/SELECT and WHERE
MySQL
IntermediateLesson 5 of 1330 min · hands-on

SELECT and WHERE

Part of the MySQL course

Your table has ten thousand products in it and you need the six that are out of stock in the electronics category. Everything you will ever do with a database is some version of that sentence: these rows, these columns, in this order. SELECT is the verb that pulls data back out, and the clauses attached to it are how you say precisely which data.

Open the terminal, connect as root (the password is easyenv, as in lesson 02), and give this lesson a fresh database of its own ...

Want to learn MySQL SELECT and WHERE in a real environment?

Click below, get a fresh Linux box with MySQL ready to go, and work through SELECT and WHERE hands-on with an AI tutor that knows your code.

Start this lessonSELECT and WHERE

What you'll learn

  • SELECT columns
  • WHERE
  • AND and OR
  • BETWEEN
  • IN
  • LIKE with % and _
  • IS NULL
  • ORDER BY
  • LIMIT

Read this lesson in your language

All lessons in this course

13 lessons
  1. 1What is MySQL20 min
  2. 2The mysql CLI and First Commands25 min
  3. 3Creating Databases and Tables30 min
  4. 4Data Types30 min
  5. 5SELECT and WHERE30 min
  6. 6Joins35 min
  7. 7Aggregates and Grouping30 min
  8. 8Indexes30 min
  9. 9Transactions and Storage Engines35 min
  10. 10Stored Procedures and Triggers35 min
  11. 11EXPLAIN and Query Tuning35 min
  12. 12mysqldump and Restore25 min
  13. 13Capstone: Design an Ecommerce Schema50 min

Explore other courses

SELECT and WHERE - MySQL (English) | Engineering Courses