MySQL: Selecting (Retrieving) Data and the WHERE clause.
MySQL: Selecting (Retrieving) Data and the WHERE clause
SELECT statements are the life of a database programmer. In this video, we'll take a peek at some of the main clauses used when selecting data:
SELECT
FROM
WHERE
GROUP BY
HAVING
ORDER BY
LIMIT
The focus of the video will be a few tricks with the SELECT clause and a handful of details about the WHERE clause.
We'll examine:
CONCAT()
Aliases
Math operations (+, -, /, *, %)
Logical operations (AND, OR, NOT)
Comparison operations
IN, BINARY, BETWEEN, and LIKE